• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to move data between date rows using VBA?

J

jcarr

New Member
I have a spreadsheet that has several thousand rows on it. There is a bunch of data under each date row that I need moved to a new worksheet up to the next date in the list. So basically if the date is 11/02/20 I need all data pulled down the list until Excel finds the next date field which would be 11/03/20, and then move all that data to a new worksheet, until it finds 11/04/20 and then does the process again.

However, I have absolutely no clue how this can be done.

Example attached
 

Attachments

  • Harmony_Ho_081420_L.txt
    41.5 KB · Views: 4
jcarr
You wrote that I ( jcarr ) have a spreadsheet that has several thousand rows on it. ...
Why did You send text-file instead of an Excel-file?
You should also show a sample of the expected results in that file.
 
You must log in or register to reply here.
Back
Top