| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What function in a formula will pull the text used in a Tab name?
Let's say I have two worksheets. Each has a specific name, i.e. Person 1 &
Person 2. In the first Worksheet, I want a heading. The heading should match the tab's name, i.e. A1 would have a formula that would show "Person 1". So that if the Tab name were to change, the formula would also reflect the change. I know that there are codes for headers, i.e. &Tab. Is there a function/formula out there that I can use? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to pull first word from text string in a column | Excel Worksheet Functions | |||
| Formula numbers and text Trying to pull a random sampling | Excel Worksheet Functions | |||
| Can i pull text with a Getpivottable formula? | Excel Worksheet Functions | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Create formula that will pull a value based on text in diff cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
