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

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Forum statistics

Threads
1,223,893
Messages
6,175,246
Members
452,623
Latest member
cliftonhandyman

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