Progressive filtering

Hi All

I have a problem and not sure the best way to tackle it.
I have 1800 rows with 18 columns; each row is an individual record.
How would I make a front page that could be filtered like the auto filter function and then be able to edit one of the sections?

Ie.
In drop down lists.
Location…. ………Bringing up 300 records
Rack Number……..Reducing the 300 down to 25 records
Reference Number. Reducing the 25 to 1 record.

Now that I have that 1 record showing, add something to the notes cell for that record.

Any help would be appreciated..

Hi Stuie,

Sorry its taken me a while to get back to you, been off duty.
Attached is an extract of the spreadsheet.

Thanks for taking the time to look.

Neil

no problem for delay...

I am putting together a template so you can have a look at it and use it if it does everything u need else u can tear it apart use parts of it what ever floats your boat...

give me a bit of time as i am at work and am tryin not to let my boss see me doing sumthing thats not my work

Your help is much appreciated.

Neil