VBA Lookup function

[stevepain]

Hi all,

I'm looking to create a macro that will take data from an input sheet, and paste it into a cell in another worksheet, based on criteria specified in sheet1.

Specifically in the attached example, the macro would copy the data in cells C8:C10 of sheet 1, then paste them into sheet 2 based on the data specified in cell B3 i.e. it would paste them into the column headed Mar-09. I intend to make this cell a drop down, so that the user can then select the next reporting month and run the macro again to paste the data into the Apr-09 column.

Sure this is possible, but having played around with several attempts and examples I've found on this forum, I still cannot crack it.

Regards,

Steve

[VBA Noob]

Maybe

Please Login or Register  to view this content.

VBA Noob

[stevepain]

Thats great VBA Noob - thanks very much for the code.
Would be interested to know what each piece of code is doing, as there are some elements that I am not necessrily familiar with in there! Would help me adapt it for my final solution which is going to involve a bit more data than this exampbe sheet over approx 60 months.

Thanks again,

Steve