Vlookup with copy and paste macro

Hi all,

I'm hoping someone can help me with this query (i've attached a sample workbook).

In the worksheet "quantification" I need to look up the description in column "C" in the worksheet "Data Sheet". I then need to return the last 75 values (columns) in the worksheet "Data Sheet" to the cells "O-CK" in the worksheet "quantification". There isn't always 75 columns in the worksheet "data sheet", sometime there will be 80, see I need to only take the last 75.

I've put an example in row 5 of the worksheet "quantification"

It feels like it should be easy but i'm getting really stuck.

Any help would be much appreciated.
Many thanks

Hi Mike,

This seems to work a treat, many thanks for helping!

Kasperblue