&[Tab] is available as data in headers but not cells?

D

Drifter

I'm tring to write a formula that looks like this: =("Weekending" &[TAB])
But Excel doesn't like it. How can I get sheet tab info into a cell?
 
A

Alex

Drifter

Using Excel alone I do know if it can be done. But you could try...

Go to Insert>Name>Define and define a name for you sheet. For example, type
'tab' in the top line and then set it equal to the name of your tab below.
That way when you type...

="WEEKENDING" & tab

Alex

....you will get what you want. This will save time but obviously cannot be
used on another tab unless you redefine 'tab'.

(2)
 
Top