I know how to extend a column within a sheet - just grab the lower-right corner and pull down. Any formula will be carried down and references to other cells within the formula will be 'updated' as appropriate so that the expanded column works just like the original.

I have a sheet whose formulae refer to cells on other sheets eg: =IF(G15="","",OFFSET('V12'!G8,G15,0)) and =OFFSET('V10'!G8,G13,0). When I attempt to expand the columns the sheetnames [V10 and V12] don't change and the cell references [G13 and G15] do.

I have a number of sheets [V1 to V18] - all identical - which I'm using to obtain the data for the summary sheet I'm working on, with the data from V1 presented in row1, the data from V2 presented in row2, etc.

I want to increase the number of V# sheets to 40 [V1 to V40] - increasing the number of rows in the summary sheet accordingly. Is there an easy way to get those complex cell-formulae without having to go through and correct the components of the formula?

Thanks for any help.

Hal