Creating Data Tables off-sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lacty - 12 Oct 2007 14:31 GMT

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

Reply to this Message

JW - 12 Oct 2007 16:03 GMT

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

> 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
[quoted text clipped - 5 lines]
>
> Atem

Reply to this Message

JW - 12 Oct 2007 16:03 GMT

typo in previous post:
=sheet1!A50
=sheet1!A50-sheet1!B50
etc
etc

> 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
[quoted text clipped - 13 lines]
> >
> > Atem

Reply to this Message

Lacty - 12 Oct 2007 16:42 GMT

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

Reply to this Message

Max - 12 Oct 2007 21:56 GMT

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.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> JW
>
[quoted text clipped - 11 lines]
>
> Atem

Reply to this Message

JP - 15 Oct 2007 17:06 GMT

Hello,

I think this might be something you are looking for.

http://www.ozgrid.com/Excel/report.htm

HTH,
JP

> 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
[quoted text clipped - 5 lines]
>
> Atem

Reply to this Message

Rate this thread: