In a spreadsheet!

[vegyjones]

I have been sent a spreadsheet that has some
drop down menus at the top of the page.

By selecting a specific content, i.e area = london
it just shows all rows that concern London!

This would be great for a filing spreadsheet at work...

Does anyone know how I can create such drop down menu's?

Thanks! :)

[mathare]

If you let me look at it I could probably tell you.

Could be done with autofilters and data validation but I can't tell exactly from that description

[Win2Win]

Use ADD

[vegyjones]

Just sent an e-mail
to your Logica address!

:D

For Keith - :pss OFF :D

[vegyjones]

Cheers mat

Top man! :wink

[GlosRFC]

Use the Data, Autofilter option....highlight the columns you wish to filter...and it will automatically insert the drop-down lists at the top of each column. These drop-down lists will also include the options to select All Entries, the Top Ten entries, Sort Ascending/Descending, and the facility to create additional Custom Filters.

Once you've applied an Autofilter to a range of columns, you can then select subsets of data, e.g. if you had a second column titled Boroughs you could select all records that have Area = London and Borough = Chelsea. To select all Chelsea boroughs (assuming there's another elsewhere in the country) you'd select Area = All and Borough = Chelsea.

[GlosRFC]

Although I suspect that Matt's probably just emailed the same info to you :D

[vegyjones]

Cheers Glos!

That's what Matt said! :)

Much appreciated Glosmeister! :wink