Hi,
Hopefully there is an answer, I have some 20 worksheets all with specific data to that worksheet. Cells can vary from A1:K110 through to A1:P1300.
I am wanting the user to use drop down lists(data validation/named ranges) to select a scenario:-
Worksheet LI 2
Month 3 (March)
Area West
Quarter if required
When selected the relevant worksheet will present the tailored data?
Advanced Filter has been used previously with a large data table, but not in selecting individual worksheets (Named Li 1/Li2 etc) because I don't know how to do this.
Can this be done? or do I need a different approach.
Many thanks for viewing this request
Steve
Hopefully there is an answer, I have some 20 worksheets all with specific data to that worksheet. Cells can vary from A1:K110 through to A1:P1300.
I am wanting the user to use drop down lists(data validation/named ranges) to select a scenario:-
Worksheet LI 2
Month 3 (March)
Area West
Quarter if required
When selected the relevant worksheet will present the tailored data?
Advanced Filter has been used previously with a large data table, but not in selecting individual worksheets (Named Li 1/Li2 etc) because I don't know how to do this.
Can this be done? or do I need a different approach.
Many thanks for viewing this request
Steve
