Structured references between worksheets

F

FredZack

Can you use structured references between worksheets? I have 2 excel tables
in separate worksheets. One table needs to reference data in column in
another worksheet. Everytime I put in = in cell of table 1 and go to table 2
(on tther sheet) I get the usual 'SHeetname'! How can I replace this with
Table name and column name as is done automatically if in same table?

AND.. what if I want an offset. That is the reference to a cell in other
worksheet is not in exact same row but off by 1 or 2 rows?
 

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

Top