I have a list of employee's that includes there shift and sub-department. What is the easiest way to look at that list and pull out a group of people? Lets say I want all the first shift inbound associates? or the second shift outbound? Would it be easier to do that with a formula or a macro?
Have you tried a flter? That would be the easiest way.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
What about a pivot table?
You can group parent - child any way you like.
In the attached find grouped Department > Sub department > Last name > First name.
Dave
I should have been more clear as to my needs. I have a spreadsheet that has to have static lists of the various shifts and departments in order to pull other information from other sheets in the workbook. The way I am doing it now is to filter the master employee list as mentioned above and then simply cut and past the information where I need it. This can take some time and can be problematic especially when adding or removing persons from the list.
I thought it might be easier and faster to have a macro or a formula be able to pull the person, shift, and department out of the master list and group them together so that all I have to do is update the master employee list from time to time and have the sub groupings automatically update without a lot of cutting and pasting.
Any Thoughts?
OK.
I retained Table1 from my previous upload. If you are not aware of it Tables resize themselves to fit their data. Saves having to edit formulas when adding/removing people from lists. Also you can change Table headers and formulas will self edit those changes automatically.
In the attached find drop downs in I1:J1. The DV (Data Validation) lists for those are in V1:W5.
The DV definitions are:
Departments:Formula:
Please Login or Register to view this content.
SubDepartments:Formula:Please Login or Register to view this content.
Then select from the drop downs and this formula will return what you want.
In I3 filled down and across until you get blanks.Formula:Please Login or Register to view this content.
Last edited by FlameRetired; 02-15-2019 at 02:04 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks