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

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

Guest

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?
 
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)
 
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

How to get range names to Apply across multiple tabs 1
Return Tab Name 3
code to unhide tabs based on cell contents 7
insert sheet tab name on the spreadsheet, not in the header 5
formula assistance needed 5
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Coping Cross Tab Formulas 3
Differenec formula: Dnt need '0' as a result;Rather have a blank c 4

Back
Top