Excel 2007 layout

Potential-Monke

Hello people. Been a while since I used all the features of Excel, but I've been given a spreadsheet with employee names and what courses they've done (including the date). I've been asked to see if I can make it look more presentable.

So I wanted to create a sheet at the start, where you have each course and a tick box, and ticking each box populates the area below it with the list of people who have that course completed. I know it's possible, I have just forgotten the wording used to research how its done!

Cheers in advance!

Taltos

Sounds like a pivot table???

Potential-Monke

Taltos wrote: »

Sounds like a pivot table???

Something like that anyway. Think I need to update my ECDL, don't even remember seeing pivot tables... I'll mess around with it and see how I get on.

Cheers!

Taltos

If you have all the source data in a clean enough table with column names - just highlight them or select the first field.
Then goto Insert on the menu/ribbon & select pivot table

You can then put in whatever layout suits you with courses as one of the header objects - as you select each course the rest of the data will refresh.,

Other option is to just use filters - and filter by course name which will show you all employee names on the matching rows.

Lovely Bloke

Would an IF+vlookup work here?