Need help with a complex loop

[bpflyr]

Here's what I have:
A small workbook (5 rows) and a big workbook(4000 rows)

Small: Big:

Date Type Total Date Type Total
11-01-05 C560 3.0 08-06-05 C560 1.5
11-05-05 1125 2.0 09-10-05 C560 3.0
? ? ?
? ? ?

I am trying to get Excel to do this on the big workbook:

-Look at the cell (date A1) above it and compare with the date on the first row from the small workbook.

-If the date is different, then copy all the data in that row from the small workbook and transfer it to the big workbook

-If the date is the same, go to the next row in the small workbook and do the same comparison/work.

-Continue to do this until all the data on the small workbook has been transfered (only 5 rows). All the other cells in the big workbook could then be blank.

-I am going to erase all the data in the small workbook each time it gets filled up, then start over with new data. I am trying to get the big workbook to remember all the old data and just continue to add data to new rows.

Thank you so much for your help. This one is driving me nuts trying to figure out. I need HELP!!

 

[Nimrod]

DUPLICATE

If anyone chooses to work on this problem they will want to refer to the DUPLICATE for a little more info ... http://www.mrexcel.com/board2/viewtopic.php?t=178925&highlight=

bpflyr.... You're better off just adding new info to the post you've already started . People generally don't like to work on duplicate posts. :wink:

 

[bpflyr]

Sorry. I thought that maybe my second post was a llittle more clear. I should have stated that.