conditional autofill???please?
 

have a workbook with 56 different worksheets (1,1a,2,2a,etc). They all have
formulas that have to point to their counterpart (1a to point to 1)
eg:AVERAGE('1'!O:O)...the question is is their any way to autofill the
formula and have it only change the '1' to a '2' on worksheet 2 and from '1'
to a '3' on worksheet 3 etc. and leave the rest of the formula alone, or is
manually the only way to change just 1 character???Any help would be very
appreciated..Thank you...signed newbie

If you put the sheet name that you want the formula to refer to in a
spare cell (say A1) - so that sheets 1a, 1b, 1c, etc. all have 1 at
A1 and sheets 2a, 2b, 2c, etc. all have a 2 at A1, then you can use
this formula:
=AVERAGE(INDIRECT("'"&A1&"'!O:O"))
Rgds,
ScottO

"tafoyavision" wrote in
message ...
| have a workbook with 56 different worksheets (1,1a,2,2a,etc). They
all have
| formulas that have to point to their counterpart (1a to point to 1)
| eg:AVERAGE('1'!O:O)...the question is is their any way to autofill
the
| formula and have it only change the '1' to a '2' on worksheet 2 and
from '1'
| to a '3' on worksheet 3 etc. and leave the rest of the formula
alone, or is
| manually the only way to change just 1 character???Any help would
be very
| appreciated..Thank you...signed newbie