Home |
Search |
Today's Posts |
#1
|
|||
|
|||
&[Tab] is available as data in headers but not cells?
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? |
#2
|
|||
|
|||
one way:
http://www.mcgimpsey.com/excel/formu..._function.html In article , "Drifter" wrote: 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? |
#3
|
|||
|
|||
Drifter
Using Excel alone I do know if it can be done. But you could try... Go to InsertNameDefine 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) "Drifter" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Source Name Not Found | Excel Worksheet Functions | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Data Table - does it work with DDE links and Stock Tickers? | Excel Worksheet Functions |