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