Hi all,

I'm requiring the ability to do something that appears rather usual but is
likely to be impossible. Hopefully not...

I want to allow users to choose from a range of buttons which in turn
display small sections of other worksheets (from the same spreadsheet) at
the bottom of the current one. Rather like having a window to other areas
of the same spreadsheet sitting on the current worksheet.

Specifically (using arbitrary examples):

- user clicks on button A whilst on worksheet "Sheet1"
- at the bottom of "Sheet1" code displays a range (say a 10x15 grid of data)
that exists on "Sheet3" in its own window
- user clicks a generic "Close window" button and the window at the bottom
of "Sheet1" goes away

This 'grid' of data needs to be updated as if you were typing into "Sheet3".

This spreadsheet drives a daily meeting and contains a long sequence of
grouped parameters. Each grouping requires a simultaneous view of a small
grid of data from elsewhere in the spreadsheet and the whole sequence so
decisions can be made. Each group requires a different grid, hence the need
to show a range of buttons which each choose a different 'grid' of data.

So there it is - perhaps I'm just going mad, but it would appear to me not
an unnaturally weird thing to want to do.

Any help will be greatly appreciated.

Many regards,
David (Sydney, Aust)