G
Gav123
Hi,
I'm hoping someone can help me with this...
Using XL2003
I have to workbooks lets call them book1 and book2. I need a macro that
looks through column D on book1 and matches numbers to column D on book2, if
a match is found on book2 and Coulumn G in that row has text in the cell,
copy the text from Column G and Column H and paste this into book1 Column I
and N (book2 Column G to book1 Column I and book2 Column H to book1 Column N)
Then fill the range of cells on book2 from column B to N on that specific row.
Book1 is shared workbook but book2 isn't.
I hope I have explained this clearly enough.
Appreciate any help that is provided.
Thanks in advance,
Gav.
I'm hoping someone can help me with this...
Using XL2003
I have to workbooks lets call them book1 and book2. I need a macro that
looks through column D on book1 and matches numbers to column D on book2, if
a match is found on book2 and Coulumn G in that row has text in the cell,
copy the text from Column G and Column H and paste this into book1 Column I
and N (book2 Column G to book1 Column I and book2 Column H to book1 Column N)
Then fill the range of cells on book2 from column B to N on that specific row.
Book1 is shared workbook but book2 isn't.
I hope I have explained this clearly enough.
Appreciate any help that is provided.
Thanks in advance,
Gav.