Macro with creation of pvot table

kateryna

New Member
Joined
Aug 28, 2017
Messages
1
Hello,

If someone can help, I will be so grateful as I have been striving 4 days with it.

My purpose is to create a macro which will do following actions for me:
1. Select a column from big data extract;
2. Make a pivot from that column (Very simple one: including lines and values);
3. Print that pivot

So, this is how I am recording my macro( visual basic I don't know).

BUT, there is one problem in the end:
when I run the macro, the final pivot is not coming how it should be (It is only Total number coming), and I don't have any idea what can be the issue.

If you have any ideas, please let me know. Thanks in advance for your time and consideration.

I cannot download the file directly to here, so in case, could you please contact me <!-- e -->katia.dmitrenko@gmail.com<!-- e -->, and I can send you the file.
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Forum statistics

Threads
1,216,445
Messages
6,130,685
Members
449,585
Latest member
Nattarinee

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