C CEG_Staffer Oct 30, 2008 #1 I am trying to figure out a way to display the worksheet name of worksheet "B" in worksheet "A" using a formla. Any suggestions?
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 Oct 30, 2008 #3 How can you display the name of sheet "6" (for example) in a cell in sheet "1"?
P Peo Sjoblom Oct 30, 2008 #4 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
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 Oct 30, 2008 #5 I am trying to avoid a lot of linking. This file is rather complex and has over 30 sheets. Any suggestions?
I am trying to avoid a lot of linking. This file is rather complex and has over 30 sheets. Any suggestions?