VBA: Pivot Table

[chaddres]

I need to create a Pivot Table using VBA. I attached a picture of sample data and the desired output. My actual spreadsheet has 40 columns but a variable number of rows.

Filter: Position Status = Active
Rows: Location Code & Home Department Code

That is the entire Pivot Table I need.

 

[chaddres]

I am sorry I got distracted today and did not reply sooner. You are a miracle worker and I really appreciate your assistant. Take care!

 

[smozgur]

I am sorry I got distracted today and did not reply sooner. You are a miracle worker and I really appreciate your assistant. Take care!

No problem at all. Glad to hear it helps, and thanks for the feedback.