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") |
#2
|
|||
|
|||
If this formula is on 'pt template' to begin with, you can remove the reference
to the worksheet. =IF('PT TEMPLATE'!A12<"",BE12,"0.00") should be =IF(A12<"",BE12,"0.00") Then when you copy the formula, it'll use the sheet that it's pasted to. If the formula isn't on 'pt template', then excel sees that you're refering to a different sheet and assumes you want to continue to use that sheet--I'm not sure how it would ever guess to use the sheet that you just pasted to. === PS. I'd drop the quotes around "0.00". =IF(A12<"",BE12,0) And just format the cell to show two decimal places. Tat wrote: 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") -- Dave Peterson |
Reply |
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 |