chacha
02-28-2008, 08:45 AM
Hi,
I can find help with code that is similar to my problem but I'm not sure about the copy part.
My problem is I have a list of numbers in Sheet1 A1:A10
I want to find these numbers in Column A of Sheet2 and copy the corresponding data in columns B,C&D to Sheet3
If the value in sheet1 does not appear in sheet2ColA i will have a MsgBox.
any help would greatly be appreciated.
I can find help with code that is similar to my problem but I'm not sure about the copy part.
My problem is I have a list of numbers in Sheet1 A1:A10
I want to find these numbers in Column A of Sheet2 and copy the corresponding data in columns B,C&D to Sheet3
If the value in sheet1 does not appear in sheet2ColA i will have a MsgBox.
any help would greatly be appreciated.