Autofill from Data Validation

  • Thread starter Thread starter JPDS
  • Start date Start date
J

JPDS

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
 
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
 
Back
Top