loop copy and past cells

**gill389** · 10-15-2010, 10:01 PM

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:

Please Login or Register  to view this content.

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.

**gill389** · 10-16-2010, 10:08 AM

Enclosed is a document, as you can see i have data two rows and then in row F3 a start date and in f4 an end date. I want to be able to change these dates and when the loop runs it goes and gets the "cost" data adjacent to the start date and continues to copy it until the "end date", and then pastes it in sheet 2.

thanks for your help

**davesexcel** · 10-16-2010, 10:30 AM

Check out the example workbook from this thread
http://www.excelforum.com/excel-gene...ml#post1873133

Your example should be
=SUMIF(B5:B43,"<="&F4,C5:C43)-SUMIF(B5:B43,"<"&F3,C5:C43)

**gill389** · 10-16-2010, 10:48 AM

Dave,

thank you, it seems like im in the right direction, but its not calculating right. Its not adding the data to much. For example if the first 2 dates have a sum in the next column of 10, the formula says 8, which is strange.

So I modified it instead of (-) i put a (+), but still the same problem.

=SUMIF(B5:B43,"<="&F4,C5:C43) + SUMIF(B5:B43,"<"&F3,C5:C43)

Instead of adding this data is there away to multiple this date instead, like a product if formula?

thanks