MIcrosoft Excel: should allow sheet increase by 1 on fill down
Hi Albert,
One way of achieving the same effect is to use INDIRECT and ROW
functions. For example, say you want a column on Sheet1 to show each
sheet's A1 value. This can be achieved by placing the following formula
into any row 1 cell (other than column A) then filling down so that
the number of cells with the copied formula equals the number of
worksheets:
=INDIRECT("Sheet" & ROW() & "!A1")
Ken Johnson
|