copy formula referencing sheet name to another sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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")
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dependent drop down dynamic range formula, off sheet. 7
formulas copying from sheet to sheet 6
Copying a cell value to another sheet by using If statement 1
INDIRECT with Sheet Level Defined Name 2
Vlookup and return sheet name also 2
Help formula that returns a text string from another sheet 1
Formula to a sheet name that is text in another cell 1
Sheet Referencing - autofilling sheet names 2

Back
Top