Hi,

I cant seem to come across this issue yet on the internet (altough Im sure it has to be there somewhere).

I have a workbook with a "Total" sheet and then 52 weekly sheets. Currently I paste a report into the weekly sheets, then use a macro to add any missing rows in the sequence (1,2,3,6 ..so a blank row for 4 & 5 is added).

I cant seem to figure out how to set up the total sheet with a formula to copy over the numbers from the weekly sheet. It is only a simple like for like copy of 1 row of data in Column C, Each attempt at a formula cant account for the added blank rows and show as REF.

I know I could just add the formula (=sheet1!C1 etc) after running the macro on the weekly sheets but I would like to have something or someway that avoids me having to add the formula new each time to the total page.

I was thinking of adding a macro button to the total page that would add a formula to each row in a column. Anyone have any suggestions how I could do this or which macro to use ?