Creating Data Tables off-sheet

  • Thread starter Thread starter Lacty
  • Start date Start date
L

Lacty

Does anyone know how to create data tables in a sheet other than the
sheet containing the input data? Someone showed me the trick a long
time ago and it has escaped my mind.

Thanks in advance for any clues or complete solution.

Cheers!

Atem
 
Do you mean that your data is in sheet1 and you want to put the data
table containing some of that data in sheet2? If so, you can just
reference sheet1 in your formulas in sheet2.
=sheet2!A50
=sheet2!A50-sheet2!B50
etc
etc
 
JW

Thanks for the response and apologies if my initial message wasn't
clear.
What I am trying to achieve is:

The input data for the table is in a sheet called,"Assumption Sheet"
and I want to create the data table directly in another sheet called
="(Summary Sheet"

Is this clearer?

Kind regards

Atem
 
Think what you posted is a limitation of Data > Table. I'd just work around
it. Create the table on the same sheet, then just "mirror" it/parts of it
elsewhere on other sheets via simple link formulas.
 
Back
Top