Hi,

I'm trying to write a macro to do the following.

Starting at cell B3 check if B3 is populated is so check cell D3 is popluated.
IF it isn't blank copy the contents from B3 and C3 to a second spreadsheet.
IF it is blank move to B4 and start the chek again.

The paste location in the second spread sheet is determined from the data in D3.
I need to find the same value on the other spreadsheet (planning to use 'Match'), move over one column and find the next empty row and paste the two cells in the corresponding rows.

The process should continue by checking B4, B5 etc until BX is found to be empty then end the routine, always checking the corresponding DX cell.

Any help would be appreciated, I have some ideas on how to do some of these things but pulling it together into one clean process is becoming complicated and I'm sure it shouldn't be that hard.