EXCEL - Macro help for hiding sheets and creating "Table of Contents"

N

ninth1dr

Joined
Jun 8, 2010
Messages
2
Reaction score
0
Hello,

I have a bunch of worksheets for different "spaces" in a house. I then have several sheets that are for a "system" to accomodate all those spaces. I have a form that I can fill out all kinds of information on each space and it will sum it up.

What i'd like to now is create a sort of "finish" button, that when hit will take information from certain cells on each sheet, and automatically place it on the "system" sheet, along with the name of the space on the first column, and then hide the "space" sheets and only show each "system" sheet. I then want to have it so I can click on the name of the space on the "system" sheet and have it unhide the corresponding "space" sheet.

I'm having problems with having it hide each sheet, and know which sheets are system sheets and which are space sheets. I also don't know how to make it so when I populate the system list with the name of the space sheet, that it will allow me to click on that name, unhide the space sheet, and go to it.

Any help or recommendations?

I can attach the sheets if it would make it easier
 
Back
Top