Filter data by the department number of each employee

Gummyworms1234

New Member
Joined
Jul 18, 2019
Messages
23
We are ordering equipment for our employees and I want the raw data of everything I have filtered by department. I could copy and paste each one to go with each department but we have too many employees throughout all three shifts and it would take forever to do it manually. I was thinking a pivot table would help but I wasn't able to get it to do what I wanted. I would like everything filtered out by department so I can send all three departments a list of the employees with the equipment they need to order. The picture I've attached is a simplified version of what I am currently working with. Thanks for the help!
 

Attachments

  • Equipment.PNG
    Equipment.PNG
    16.7 KB · Views: 13

Gummyworms1234

New Member
Joined
Jul 18, 2019
Messages
23
Could you upload a sample workbook to a free site such as dropbox.com or google drive & then share the link here?
It will make it easier to test and find a solution.
Or at least post your samples as table instead of image, using XL2BB is preferred.
My coworker was able to work his magic and help me with what I needed yesterday! Thanks for the help!
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Watch MrExcel Video

Forum statistics

Threads
1,129,384
Messages
5,635,985
Members
416,891
Latest member
Okomomo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top