Macro to create a Summary Sheet from a Pivot Table

Try

Please Login or Register  to view this content.

Hello Jindon,
I will test the code with my actual data
In the meantime, is it possible to display the numbers in Column E and G on the Summary Sheet with Thousands separator and two decimal places.

eg 17500 to show as 17,500.00
193987 to show as 193,987.00
100 as 100.00

Thanks for your time and help

Originally Posted by rehana402003

I will test the code with my actual data

Post back with the result first, then think about the cell formatting if it was successful.

Dear Jindon,
The code works but there is a slight problem
My pivot table shows two lines in the headers. Please see Cell J2 in the attached sample
which shows the word 'Value' and with that the result is shown on the Summary Sheet
Would you please see to fix this problem and also the formatting on numbers in Col E and G on the Summary sheet with Thousands separator and two decimal places

Many thanks for your time and help
Have a wonderful year

Regards

1) Change one line in "test" sub procedure.

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

2) Replace the lines in "DataOut" sub prociedure.

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Thanks a million Jindon.
Works like a charm.
Post marked SOLVED

God Bless you

Regards