A
Ali
Hi there, i have a workbook consisting of approx 70 sheets, named 1 - 70.
One sheet has formuals that read cells from all the others sheets.
Example
C1 = '1'!$A$4
C2 = '2'!$A$4
C3 = '3'!$A$4
I need to drag the formula down from C1:C70, but can't find a way that it
increments sheet numbers. It is taking for-ever to cut and copy, and then
change the sheet numbers individually. This sheet also has formulas reading
C1:C70 all the way through to AK1:AK70 so too many cells to copy.
Any ideas on how to increment sheet numbers each row down.
many thanks
Ali
One sheet has formuals that read cells from all the others sheets.
Example
C1 = '1'!$A$4
C2 = '2'!$A$4
C3 = '3'!$A$4
I need to drag the formula down from C1:C70, but can't find a way that it
increments sheet numbers. It is taking for-ever to cut and copy, and then
change the sheet numbers individually. This sheet also has formulas reading
C1:C70 all the way through to AK1:AK70 so too many cells to copy.
Any ideas on how to increment sheet numbers each row down.
many thanks
Ali