If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Autofill from Data Validation
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 |
#2
|
|||
|
|||
Autofill from Data Validation
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 |
#3
|
|||
|
|||
Autofill from Data Validation
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 . |
Thread Tools | |
Display Modes | |
|
|