Sheet setup and search

[Ray]

Hello -

A friend has asked for some help and I'm not sure where to begin so
that the best solution is created ...

This person works for a Community Center, responsible for sports
activities. One of the things he keeps track of is which referees
have worked at which fields. Currrently, his tracking sheet has
referee names in column A (starting at A5) and the fields that they've
worked at in column B -- it's likely that a cell in colB will have
multiple field names in it (separated by Alt-Enter).

He wants to create a way to enter a field name (on a different sheet
within the WB) and get a list of the referees who have worked there.
What's the best way to do this? I suspect his tracking sheet needs to
be modified to allow for a search, but how?

Any help is greatly appreciated!

TIA,
Ray

 

[Toppers]

The data would be better organised with names in column A and fields
(activities?) in column B onwards e.g, B1=Football, C1=Basketball etc.

 

[Ray]

The data would be better organised with names in column A and fields
(activities?) in column B onwards e.g, B1=Football, C1=Basketball etc.

OK, as I suspected .....

So let's same that I have Names in col A (starting in A5), phone
number in col B (B5) and field names across the top (C4-h4), with an
'X' in the row below the field name for each person that can work at
that field. How do I set it up that the user can enter a field name
on a different sheet and get the names and comments that can work that
field ... ? VBA solution is ok....

 

[Sandy Mann]

Without going to another sheet you cold use Autofilter to filter for any one
activity

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk