+ Reply to Thread
Results 1 to 2 of 2

Adding new rows

  1. #1
    Registered User
    Join Date
    04-03-2024
    Location
    Hong Kong
    MS-Off Ver
    365
    Posts
    1

    Adding new rows

    Hello everyone!

    I have an excel file has attached. The data has time stamps arranged from 6am to 6pm everyday for a whole year. But we decide to make it 12 am to 12pm everyday. Since the data is in 10 minutes time stamps, this means I need to add rows for 12am to 5:50am and 6:10 pm to 11:50pm everyday for a whole year. Does anyone know a faster method to do this without having to create this rows for each day?

    PS: The attached data is a sample. For every day, I have additional set of data. This means for the new rows created everyday i.e., 12am to 5:50am and 6:10 pm to 11:50pm, I need to copy and paste these additional data as well.

    Thanks alot for the help.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    897

    Re: Adding new rows

    Hi there,

    Try the attached file.
    The macro will ask for the year, then generate the list from 1st Jan to 31st Dec in 10 min steps on the active sheet.


    Please Login or Register  to view this content.
    If your Question is answered; please mark it SOLVED. If you are happy with a member's solution, say 'Thanks' and click the 'Star' to Add Reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA to stop adding table rows after X number of rows
    By Dbroek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-09-2022, 12:22 AM
  2. Replies: 13
    Last Post: 07-16-2016, 10:53 PM
  3. Converting rows to columns and adding extra rows as required
    By teco in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-09-2016, 04:18 PM
  4. Deleting rows in protected worksheet, then adding new rows
    By jokris in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2016, 05:50 PM
  5. Adding rows to multiple sheets when adding new item using DataForm
    By pandora1a2b in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-11-2014, 01:00 PM
  6. Comparing rows in spread using VBA and adding rows based on the comparison.
    By mahanteshdh in forum Hello..Introduce yourself
    Replies: 3
    Last Post: 08-04-2014, 09:29 AM
  7. Adding rows - same amount of rows as value in cell
    By DamienC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2008, 06:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1