Getting a Sheet to Choose to Display Other Sheets

K

Kyle P.

Hello,
I have a payback workbook with about 6 different payback sheets, for the
six different years in our payback range. I would like to create a master
sheet and link the 6 different payback sheets to it, so whenever I change
some numbers on my formulas sheet, the master sheet selects the correct
payback sheet to be displayed.
In short, I would like to know if I can program a sheet to display other
entire sheets?
Seems tricky to me, feel free to ask for clarification of the problem,
It's difficult to word.
Thanks as always,
Kyle P.
 

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