Use VBA to create a more complicated pivot table, examples included

question610

New Member
Joined
Jul 3, 2017
Messages
29
I have a spreadsheet that shows information about each office location, the different departments in that department and various attributes about that department. Using this information, i need to create a table for each office location with each department as a row. There will be 4 required columns which are universal information given for each department and one last column called comments, which all are the other remaining attributes.


First, I want to get the information in the right table format. This is the hardest and most important part.

Data:
1t626d.jpg


28i50t4.png
[/IMG]
2duas2.png
[/IMG]

[/IMG]
Desired Results:
I want the user to be able to choose what locations and within that location, what departments to include.
Ex: I want to know about Engineering, HR and Sales for New York (but not Accounting) and Sales and PR at Tokyo.

2qbdlhu.png



 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Forum statistics

Threads
1,224,828
Messages
6,181,217
Members
453,024
Latest member
Wingit77

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
Back
Top