Sorry, I probably did not clarify enough, I would like the report recipients
to choose their desired reporting location or name e.g. directorate or
department name from the drop downs, which would then automatically show the
data on the next sheet (but limited to only the relevant data). I am aware
this is possible in VBA, but I would to know if it is feasible in Excel only.

Thanks

"Pete_UK" wrote:

An easy way is just to apply a filter to the appropriate column.

Hope this helps.

Pete

On Mar 10, 2:54 pm, JPDS wrote:
I have a list of staff in sheet 1, along with where they work in the company
i.e. their geographic location, their department name, their section and
their team name etc.

How do I use a Vlookup to show me all the names of staff from the list who
are in 'x' department and/or 'y' team name?

Thanks

.