Relative reference to a table across multiple worksheets

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

Guest

I need to reference data in a table located in a main worksheet from multiple
subsequent worksheets. Each subsequent worksheet will reference cells in the
same rows, but in different columns in the table.
 
What do you want to do? You say "reference". What do you mean by that?
Are you trying to write a formula? Do you want to simply link one cell to
another on another sheet? HTH Otto
 
By reference, I mean use the values in the main table's cells within a
formula. I have identical formulas in multiple worksheets that only vary by
which cell values are used from the main table.
 
I think you mean cell "addresses" when you say cell "values". Loop up
"VLookup" in Help I think that is what you want. You also may want to
simply link a cell in one sheet to another cell in the master sheet. HTH
Otto
 
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

Excel 2013 Merge Data 2
Need Macro... 8
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How to reference a cell from anther workbook without opening it 0
VBA - retrieve data on last create named range from previous inserted named range 0
append multiple worksheets data into a single multi-dimensional array 4
Excel lookup across entire workbook 1
Named Formula across multiple worksheets 4

Back
Top