Excel VBA - Advanced Filter Variable Cell Reference

[focusmm]

Hi, I'm new to your forum, so I will try and be concise:
I am using the advanced filter function in Excel and want the list range and the beginning anchor cell in the copy to range to be variable. The user will select the level of detail from a pull down menu, which dictates the ranges in the advanced filter. When I use the record function for the macro, it only records the ranges selected while recording vs being variable:

Please Login or Register  to view this content.

The range U1:X911, the U needs to flex to U, V or W depending on the user's selection and the copy to range B13:E13, the B needs to flex to be B, C or D depending on the user's selection.
Thank you.

[StephenR]

How does the user make their selections?

[focusmm]

drop down menus that create the variable U,V or W and B,C,or D

[StephenR]

If your drop downs are in A1 and B1

Please Login or Register  to view this content.

[focusmm]

thank you.