You could add your own slider control or up/down button which hides/unhides
rows as needed.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Matthew Turinski" wrote in message
m...
(Matthew Turinski) wrote in message
om...
I have two tables in one spreadsheet, directly below each other -
different column headings for each. I'm wanting the frozen panes for
the column headings to change as I scroll down to the second table.

An If statement specifying the heading may be entered, referenced to a
cell that dispays the number of times i've clicked down - by how do I
do that?

Thanking you in advance for any input...

Thanks to Rob for the help - the new window works for the spreadsheets
that only have a couple of tables below, but for 3 or more, there are
too many on one page...there must be another way!!