Select multiple rows depending on value of A1

[rickschm]

Hi everyone
Sorry for sounding a little too green behind the ears
I have a spreadsheet with employees and data listed. The drop-down in A1 lets someone select the employee and then it hides the rows for all other employees. I want to add the names of supervisors in the drop-down of A1 and have it select only the employees under that supervisor and hide the rest. The number of employees under each supervisor ranges from 3 to 6. This is what I have to hide the rows when selecting a single employee :

Please Login or Register  to view this content.

My workbook has stats data on the "Master" sheet(sheet #1) and analysts and supervisors on "Analysts" sheet(sheet #12). Data validation for cell A1 on "Master" sheet has all the analysts and supervisors in the first column of "Analysts" sheet with title "Select Analyst" in cell A1. I modified the "Analysts" sheet to show supervisors from B1:I1 and listed the analysts in the appropriate columns below them. Not sure how to make it select the analysts when someone selects the supervisor on "Master" sheet

[xladept]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[rickschm]

stats_clean.xlsm

Attached is a sample of the workbook. On sheet "Master", if you select an analyst (ana1, ana32, etc)it hides all rows of stats except that analyst. The second worksheet has the anaylsts grouped under their respective supervisor. I want to be able to select a supervisor (super1, super2, etc) on "Master" sheet in A1 and have it hide all the rows except the analysts listed under that supervisor on worksheet 2

[xladept]

Reconsidering - I'll post again here later.

[xladept]

Hi Rick,

It didn't work until I used the Trim - try it:

Please Login or Register  to view this content.

[rickschm]

This is great. Had to tweak it a little bit to match my actual workbook but it works perfectly. I even brought it over to another monthly report and was able to get it working there also Wanted to add some reputation but the board said I couldn't give you any more until I gave someone else some lol

[xladept]

Hi Rick,

You're welcome! (The reason I mentioned the Trim is because it means that you've got leading or trailing blanks in your data fields.)