mpouliot8168
New Member
- Joined
- Feb 10, 2012
- Messages
- 9
Hello I am trying to automate a task and there are a couple layers. I will try and walk you through it...let me know anything is unclear:
I have a summary tab with columns each column has a unique number in the 2th row. The number of columns can vary, but the row of the indentifier never changes. These unique numbers line up with entries on other sheets which are listed in rows (idenfiers found in first column of each row). I would like to create a drop down menu on the summary page so that I can toggle between so that I can show ONLY the choosen column on the summary page as well as hiding all of the rows NOT assosicated with that unique number on the other sheets (additional 13 sheets).
I will then need to password protect each sheet and the workbook. The reason for this is that the people I am sending this info to can only see their repective information so doing this manually can result in error. Plus I am handing this off to someone else it need to be seemless if possible. I know this can be done, please help!
Thank you in advance.
I have a summary tab with columns each column has a unique number in the 2th row. The number of columns can vary, but the row of the indentifier never changes. These unique numbers line up with entries on other sheets which are listed in rows (idenfiers found in first column of each row). I would like to create a drop down menu on the summary page so that I can toggle between so that I can show ONLY the choosen column on the summary page as well as hiding all of the rows NOT assosicated with that unique number on the other sheets (additional 13 sheets).
I will then need to password protect each sheet and the workbook. The reason for this is that the people I am sending this info to can only see their repective information so doing this manually can result in error. Plus I am handing this off to someone else it need to be seemless if possible. I know this can be done, please help!
Thank you in advance.
