Data validation selection then Lookup Worksheet

SteveWebb

Board Regular
Joined
Feb 20, 2002
Messages
73
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
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Watch MrExcel Video

Forum statistics

Threads
1,109,540
Messages
5,529,434
Members
409,876
Latest member
Akash Yadav
Top