Macro with advance filter and dependent data validation lists

[paraffin]

I have a spreadsheet that has two data validation lists that are dependent of each other (e.g. Strategic Priorities 1,2,3,4,5 & Developmental Priorities 1.1,1.2,2.1,2.2,2.3,.....). I want to write a macro that will advance filter based on the data lists and then print (e.g. SP1 and DP1.1 will filter based on values and then print).

The problem I have is that I wish to print all of Strategic Priority 1 (or 2,3,4,5) in one click but with a separate printed sheet for DP 1.1 , 1.2, 1.3 etc. (so in theory I should have 3 sheets of printed paper for Strategic Priority 1)

I would be extremely grateful for any assistance in doing this.

Thanks
Alwyn

 

[paraffin]

Any help on this please? Getting quite desperate now