Prev: CANNOT SHIFT OBJECTS IN SHEET
Next: Pallets w/varying sizes & weights need to fit in restricted space
From: FredZack on 28 Apr 2010 14:15 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? |