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
 

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

Similar Threads

Button for every sheet one new email 0
hide multiple worksheets based on a formula value in one cell 1
For Each Next; Multiple Arrays; VBA; Excel User Form; 1
Excel A CountIF question... I think 2
Excel, assign cells in multiple worksheets from one sheet 1
hiding sheets 1
Unhide Multiple Sheets 2
toolbar "button" for hiding/unhiding sheets 2

Top