Newbie Alert - need to select columns using a filtered row

[empach]

Hi,

Apologies if this sort of thing gets posted all the time but I really do not understand the terminology associated with what I consider a difficult issue, so I'm asking for your help!!

I have a spreadsheet with rows of personnel and their locations that I can filter to show only one location. And I have columns which show the skills sets associated with my workplace. But, not all personnel can do all skills sets. What I want to do is select a location and have excel only show the skills set associated with that specific location.

Thanks in advance - any help would be greatly recieved!!

 

[lol.xls]

Have you considered converting this data into a table? It could be filtered/sorted dynamically based on any data point.

 

[empach]

Hi,

No, I haven't thought of that, neither would I know how to do that. Would I be able to auto select columns from a filtered row in a table??

 

[empach]

This is a selection of what I've got

Quarter One Specialist Training

October to December

Animal Rescue

Lectures

Incident Command Structure

Zoonoses

Safe Approach to Animals

Practical

Handing

Slinging Techniques

Water Carrier Training

Flexitainer single use

Flexitainer twinned use

Pump operation

Life Jackets

Light Portable pump

Hydrants and water supplies

HVP Training

Vehicle Activities (RTITB Quailified)

Prime Mover Driving

Prime mover Operation Load /Unload

Prime Mover Assistant

Hose deployment /Retrievial

Deployment & Retrieval

Siting Hydro-Sub Module

Station Number

Station Name

Watch

Role

Name

Brigade Number

03

Billingborough

RDS

WM

Jack Moss

1856

03

Billingborough

RDS

CM

Gary Bellamy

3416

04

Billinghay

RDS

CM

Dan Moss

4089

04

Billinghay

RDS

CM

Matthew Pearce

3652

04

Billinghay

RDS

FF

Richard Clarke

1870

<tbody>
</tbody>

What I want to do is be able to select station number 03 and only show columns animal rescue and HVP training. When i select station 04 I want to display the columns Water carrier and deployment and retieval.

I hope this makes sense to someone!!

Many thanks!!

 

[lol.xls]

This should get you going
The Essentials of Creating and Working with Tables in Excel 2007 - For Dummies