Showing of different Sheets on demand within one table

L

Leopold

Hello,

I'm sorry for my very poor English.

I hope I explain my problem so that you can understand. How can I do the
following:
I have one Excel table (A) with different sheets (1, 2, 3, ...). I want
an overview on sheet 1. In this index of content I have different themes
(A.a, A.b, A.c, ...). In this state all the other sheets (2, 3, 4 ...)
should be hidden. If I take a mouse click on theme A.a the sheets 2 and
3 should be showed. But the other one not. If I click on theme A.b the
sheets 4, 5 and 6 should be showed. The sheets 2 and 3 should be hidden
again. And so on.

How can I do this?

Kind Regards
Leopold
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top