variables

[khalid79m]

I have spreadsheet with follwing coloumns

A = Name (Employee Name) over 500
B = Staff Number
C= Team Leader (approx 10 people per team leader )
D = Manger
E = SKILL TYPE ( THERE ARE AT LEAST 52 SKILL TYPES)

I need a sciprt which will filter skill type ( say the skilltype is = "ADF" )
then once the filter is finished, then work out how manu unique managers there are and print a report for each manger under that skill tyoe (showing all the employees and team leaders that fall under him.

i can quite easily filter ADF then Filter Each Manager individual but the problem I have is when these managers change I have to change my scripts.

Can anyone help

(in the test1 file you will see the scenario and the end results that I want lower down)

[khalid79m]

I have been looking into the above

I can set macro to filter the skill type to adf
then advance filter the unique results under the manger coloumn to the bottom of the sheet

the set the filter to filter to the cell refernce where these unique mangers names are held to get the information i need.

this is a long winded way of diong it is there anyway to simplyfy this.

any help thanks