Excel VBA: Copy and paste down cycle
Experts,
I have an example spreadsheet that illustrates what I am trying to do. I am looking for a way to take my date column and copy the first the record all the way down till it reaches a new date. Then it will take the new date and copy paste down.. This is a cycle that I would like it to repeat till End is found.
This will save a lot of manual work for us as we are compiling monthly data from various spreadsheets.
I have attached a spreadsheet for a better understanding.
Thank you SO much!
Example-data-file.xlsx
I have an example spreadsheet that illustrates what I am trying to do. I am looking for a way to take my date column and copy the first the record all the way down till it reaches a new date. Then it will take the new date and copy paste down.. This is a cycle that I would like it to repeat till End is found.
This will save a lot of manual work for us as we are compiling monthly data from various spreadsheets.
I have attached a spreadsheet for a better understanding.
Thank you SO much!
Example-data-file.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you! Learned something new!
Saurabh...