Displaying Worksheet name in cell using formula

C

CEG_Staffer

I am trying to figure out a way to display the worksheet name of worksheet
"B" in worksheet "A" using a formla. Any suggestions?
 
C

CEG_Staffer

How can you display the name of sheet "6" (for example) in a cell in sheet "1"?
 
P

Peo Sjoblom

Put the formula in sheet 6 then
link to it. Just copy the cell with the formula, go to
sheet 1 and do edit>paste special and select paste link

--


Regards,


Peo Sjoblom
 
C

CEG_Staffer

I am trying to avoid a lot of linking. This file is rather complex and has
over 30 sheets. Any suggestions?
 

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

Multiply with Vlookup value from another Worksheet 0
Worksheet Names using Macros 5
Copy addition formula of non-consecutive horizontal cells 2
Moving columns with formulas gives #REF! 0
Formula: Counting Cells on Different Worksheets 3
Hide columns based on row values 2
accurately payservices both scheduled and actual cases. 0
Carry over YTD balance to next worksheet 4

Top