How do I create a formula that references a specific tab in Excel?

  • Thread starter Thread starter fberg
  • Start date Start date
F

fberg

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.
 
Worksheets can be referred to either by name or index number. Use the index
number to solve your problem.
 

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

Reference the same cell based on tab name 1
Reference a Worksheet Tab in Formula 11
How to get range names to Apply across multiple tabs 1
Variable to rename a tab in a worksheet via VBA 5
Named Ranges and Dynamic Formulas 3
How to Auto Reference Worksheet Tab ID's in Formulas? 9
linking a worksheet by a cell reference 3
Refer to other tabs in formula 2

Back
Top