I need help creating a loop that will go down a row and copy data to the adjacent cell and paste that data until the condition is met.
I have data in cells a1:a1000 which are dates and then in cells b1:b1000 data.
In cell h1 is a date which will be any start date the user enters: h1: 2/1/2008
In cell H2 is the end date which the user enters: 3/1/2009
I need the loop to find the first date entered in h1 in column and once found continue to copy all the data to the adjacent going down until the end date is reached which comes from H2. ALL THE dates increase by month and year. I then need it to copy and paste to another cell in another worksheet.
I only have a little bit of the program:
I am not sure which loop to use and how I would tell the loop to go down in the row A, and when it finds the date to copy the data to the adjacent cell and keep going until the end date which comes from H2-saved as "Y" in the program. Then I need it to take all the data and paste it in another worksheet.
Please let me know if you can help... The rest of the program after that I can do, loops are one of my biggest weaknesses.
Bookmarks