| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dragging formulas with sheet names
My sheets are named TM1, TM2, TM3 etc. to TM100
My formula reads ='TM1'!S$46 How can I drag the formula down so the subsequent formulas read.... ='TM2'!S$46 ='TM3'!S$46 etc. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reference to sheets without using sheet names | Excel Worksheet Functions | |||
| Get other sheet names into a column | Excel Worksheet Functions | |||
| Using Sheet names in formulas | Excel Worksheet Functions | |||
| How do you apply Names in formulas? | Excel Discussion (Misc queries) | |||
| How can I show sheet names in different colours | New Users to Excel | |||
Threaded Mode
