Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a formula that references a specific tab in Excel?
How do I create a formula that references a worksheet tab without using the
tab's name? I'm using the formula in a different file from the source data I'm referencing. This source file will be written over constantly with a new source file. The file name and path will always remain the same, and I always want to reference the same worksheet tab and cell, but the worksheet tab's name will change. In other words, I always want my file to reference cell A2 in the 2nd tab from the left from the source file. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a formula that references a specific tab in Excel?
Worksheets can be referred to either by name or index number. Use the index
number to solve your problem. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I am looking for help on how to create a specific formula | Excel Worksheet Functions | |||
How to create specific formula | Excel Worksheet Functions | |||
Can I create a formula to find a specific value within a group of. | Excel Worksheet Functions | |||
How do I create a formula to add values from specific fields? | Excel Worksheet Functions | |||
How do I create a formula to add values from specific fields? | Excel Worksheet Functions |