Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
How do i create a conditional sum? | Excel Worksheet Functions | |||
conditional formatting conflict? | Excel Worksheet Functions | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |