Macro to insert data in specific cell based on criteria

I'm re-posting this in the hope that someone can help.

In the example enclosed I'd like to add some code to a command button on Sheet 2 so that the data on Sheet 1 cell M27 is entered in to cell C12 on Sheet 2 because of the criteria set out in Sheet 1 cells H2 (Week) and M2 (Identifier) - the data is inserted in to the relevant point on the matrix in Sheet 2.

Any help appreciated.

Thanks Steve

Thanks for the reply -

That would simply copy and paste the value from cell M27 on sheet 1 to cell C12 on Sheet 2.

Sheet 1 will constantly change - the unique identifier, the week and the value in M27 will change.

I'd like the macro to look up the week number (H2) and the identifier (M2) and insert value in cell M27 into the relevent place in the matrix on Sheet 2 - weeks are on row 6 and identifiers in column A.

Cheers

Originally Posted by MarvinP

Hi,
I get it now. Try calling this code from you button click,

Please Login or Register  to view this content.

I've added this code to the command button and it comes back with the following runtime error 1004:

'Unable to get the Match property of the WorksheetFunction class'

Ok. I know I'm a bit of a thickie with this but...

The above code works perfectly if the command button is on Sheet1 but it's on Sheet2. How do I change the above code for this?

HI, SAsplin, your task can be easily solved with formula or with code, please check attachment