VLOOKUP inside macro to copy/paste values?

Ello,

So... Going try and explain it as simple as possible.

We use 2 workbooks at the office, Wb A has data entry all day long, Wb B is used at the end of the week, to collect certain aspects of Wb A. Wb B is using the vlookup to Wb A to get an entry from A1 (which refers to Wb A) to reflect it in C1. Cell A1 is always entered manually as we do not know which data is requested. Wb B Sheet 2 has all entries from Wb A. Is it possible to use the VLOOKUP within a macro, that, if executed it copies the value from C1 and searches through the entries in Sheet 2, and then pastes the value in the according C row?

Doesn't sound very clear, does it :p..

I have attached a mini version of what I mean.

Please Login or Register  to view this content.

I will try to answer any questions as quick as I can and any help is really appreciated.

That doed exactly what I need. 1000 thanks, +rep