| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help with formula fill down
in sheet2 i have formulas that copy information from sheet3. sheet3:sheet25 are all the same templates. How can I fill down the formulas and have them change only the sheet name? All of the formulas is allready locked with the $ sign except the sheet name. a4='sheet 3'!$I$2 a5='sheet 4'!$I$2 a6='sheet 5'!$I$2 etc... -- comotoman ------------------------------------------------------------------------ comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292 View this thread: http://www.excelforum.com/showthread...hreadid=472767 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula will not fill correctly due to odd number rows | Excel Worksheet Functions | |||
| Fill formula question | Excel Worksheet Functions | |||
| Possible? formula in one cell can fill another cell | Excel Worksheet Functions | |||
| Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
| Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
Threaded Mode
