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 |
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) |