select range to copy, find values and copy

Hi guys,

Hope you can help on this one,


I have a base document that i can import another data document with a button (this is working).

I then have another WS ("search") in the base document with lots of identifiers which I want to use as my search range to look through the document that I just imported (column A).

I need a msg to ask the user what month they would like to find the $ value on (Ie, January) in the imported WS... this way it doesnt copy the entire line only cell in the selected month column.

Then I want to the user to be able to click a button that will check through the identifiers on the "search" WS and if the same identifier appears in the imported WS in column A, then for the $ value in the column selected to be copied to the search Range work sheet.


If the idenfifier is not matched then in place of the $ value copied can be the string "no in XXX WS" .

I have attached the document with dummy data in each work sheet with details more cleary what I have meantion above.

Thanks in advance everyone