Spreadsheet within spreadsheet?

[Chris]

I'm in urgent help and I'm hoping you can provide the answer I'm after...

I have two spreadsheets. I want to be able to click a cell on one sheet
which drops down the contents of another spreadsheet.

Is this possible?

Thanks ever so much for your help.

Regards
Chris

 

[Peo Sjoblom]

You can use data>validation, first name the list on the other sheet
(insert>name>define)
then use data>validation, allow list and use

=MyList

(replace MyList with your own name)

 

[Chris]

You can use data>validation, first name the list on the other sheet
(insert>name>define)
then use data>validation, allow list and use

=MyList

(replace MyList with your own name)

That just gives me a drop down with a list of options to choose from.
Upon choosing it replaces what was in the cell with what I chose.

I'm after something which will show a preview almost of another
worksheet. Something that could be switched on and off i.e. like
expanding and collapsing?

Thanks for your help

 

[Tom Ogilvy]

Not really anything that supports that. You can do to the Window menu and
choose new Window, then go to the new window and select the other sheet.

Another possibility
If it is only a portion of the other sheet, you can use formulas to link to
that sheet and show the values displayed there.
You could set up the formulas with the IF function so you could have them
either display the information or display nothing

=if(A1="","",Sheet2!B9)

as an example.

 

[Jay]

I have two spreadsheets. I want to be able to click a cell on one sheet
which drops down the contents of another spreadsheet.

This isn't quite what you asked for, but you might want to check out
Data >> Group and outline >> ...
This is a way to organize rows in an "outline" style, where you can expand
and collapse outline levels. Maybe it'll meet your need.