| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
copy formula referencing sheet name to another sheet
When I copy the formula below to several worksheets it copies the old sheet
name into the new sheets. I would like it to reference the sheet name that the formula is copied into. Is this possible? =IF('PT TEMPLATE'!A12<"",BE12,"0.00") If a new sheet name is 'James' I would like the formula to be: =IF('James'!A12<"",BE12,"0.00") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
| How do you copy a formula without incrementing some constants? | Excel Worksheet Functions | |||
| Copy text from same cell on every sheet to title sheet? | Excel Discussion (Misc queries) | |||
| formula referencing another workbook | Excel Worksheet Functions | |||
Threaded Mode
