Excel macro to copy paste a particular range of cells as values in multiple tabs

Hi,

Please refer to my attachment below.

This is an excel template with lots of formulas.

In cell J10 of the instructions tab you can see a date mentioned
If that date is the first date within each item tab a particular range of cells need to be copy pasted as values.

For example j10 is 1/27/2013 matches with the cell AU3 of the item level tab

which means AU10 to BA11,AU23 to BA24,AU36 to BA 37 and AU49 to BA50 of each item tab needs to be copy pasted as values

if J10 is 2/3/2013 which is BD3 of each item tab

then BD10 to Bj11,BD23 to BJ24,BD36 to BJ 37 and BD49 to BJ 51 needs to be copy pasted as values and so on in each item tab

I want a VB code with a loop to copy paste as values. Hit Alt+F11 to find the VB code In module Test which I have used

The constraint is that I need to enter a huge code if i follow the coding I have started off with.


Please help me solve this issue

The rows Actuals and adjustments needs to be copypasted as values based on the date that matches in the cell J10