Hi,

Pls help me with this. I have two workbook.

Workbook 1 - with columns A B C D

I need a macro that will do the following:

1) From workbook 1 - If the cell D1 = "x" , then I need to copy cells
A1& B1 to workbook 2.

2) I need the macro to go down the page in workbook 1 to identify the
criteria (I don't know what row it will end).

3) When pasting to workbook 2, i need the macro to identify a blank
row before pasting (there could be data there previuosly that i do not
want to delete).

Thankyou so much
KH