View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kyle P.[_2_] Kyle P.[_2_] is offline
external usenet poster
 
Posts: 7
Default Getting a Sheet to Choose to Display Other Sheets

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.