Filter data by the department number of each employee

[Gummyworms1234]

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!

 

[mart37]

In a pivot table you can place BOSS, EMPLOYEE and DEPARTMENT in the FILTER option.

 

[Gummyworms1234]

In a pivot table you can place BOSS, EMPLOYEE and DEPARTMENT in the FILTER option.

In the pivot table field list, the only fields I currently see are Boss and Jon. Do you know how I could get boss, employee and department to appear in the field list or how I can make the two fields available do what I need them to do?

 

[mart37]

Do you have a table with the fields BOSS, EMPLOYEE, DEPARTMENT, EQUIPMENT etc.

 

[Gummyworms1234]

I don't have a table with those fields.

Do you have a table with the fields BOSS, EMPLOYEE, DEPARTMENT, EQUIPMENT etc.

I've attached an image so you can see what I see. If you tried the same thing, are you seeing more fields than the two I see?

 

[mart37]

I assume you want to register all data. That's why you need a table with all the information. When that table is ready you can make overviews with a pivot table.
An example:

Department	Boss	Employee	Equipment	Size	Quantity	Ordered
12	Jon	CJ	A
12	Jon	CJ	B
12	Jon	CJ	C
12	Jon	CJ	D
12	Jon	CJ	E
12	Jon	CJ	F
12	Jon	Alex	A
12	Jon	Alex	B
12	Jon	Alex	C
12	Jon	Alex	D
12	Jon	Alex	E
12	Jon	Alex	F

 

[Gummyworms1234]

I assume you want to register all data. That's why you need a table with all the information. When that table is ready you can make overviews with a pivot table.
An example:

Department	Boss	Employee	Equipment	Size	Quantity	Ordered
12	Jon	CJ	A
12	Jon	CJ	B
12	Jon	CJ	C
12	Jon	CJ	D
12	Jon	CJ	E
12	Jon	CJ	F
12	Jon	Alex	A
12	Jon	Alex	B
12	Jon	Alex	C
12	Jon	Alex	D
12	Jon	Alex	E
12	Jon	Alex	F

That is ideally how I wish I received the data, but the initial image I uploaded is the only way to receive it. Based on what I have, do you believe it'd be possible to do what I am trying to do with an index formula or vlookup.

 

[Akuini]

I might have an idea, but with VBA not formula.

so I can send all three departments a list of the employees with the equipment they need to order

Do you only have 3 department? In your example they are department 12,34, & 76?
By using your example, what the result should look like?

 

[Gummyworms1234]

I might have an idea, but with VBA not formula.

Do you only have 3 department? In your example they are department 12,34, & 76?
By using your example, what the result should look like?

I only have 3 departments and I'm open to any suggestion. Based off of my example, I would create 3 tabs for each department and I'd like each table to go the corresponding tab if possible with or without VBA or a formula.

 

[Akuini]

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.