Hi

Need some assistance in creating a function in Excel 2007.
Attached is a sample of a table I am working with Actual data table and Stored data table.

In the first table in cell B2..G2, that has formula which are based on live data. When the formula is correct, it will display a figure and when it is not, it will display blank. The rest of the rows 3 to 8 will populate accordingly based on row 2.

Anyway, I need to create a function that
• When cell B2 (for example) gets populated, the function will copy B2..B8 and paste to B11..B17. Each Column is independent of each other.

• When B2 goes blank, data in B11..B17 will still remain. For example in column F, the cell F2 is blank but the data in F11..F17 is still there.

• When B2 get populated again, it will overwrite cells B11..B17.

• If the date and time (row 7 & 8) can work with the function, it would be great.

Thanks in Advance
Regards

SivaK