VBA and Macros for MS Excel - Chapter 12 PivotTables

shades

Well-known Member
Joined
Mar 20, 2002
Messages
1,550
Just a note to let you know that I have been tasked with a project that has been time-consuming, trying to teach people how to maintain an XL database, data integrity, then generate reports (through Pivot Tables, then reformatting, etc.) - all the while tyring to actually do it. Not a pretty sight!

However, today I had time to step back and look at the reports, the Pivot Tables, and the needs. By following the concepts in Chapter 12 in VBA and Macros for MS Excel I have been able to already complete half of the project, just building code step by step. I plan to finish the rest today/tomorrow, and then let the non-XL users try it out, see if they can break it.

So, thank you, thank you, thank you!
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
thank you! It's great to hear how the book is helping people! :biggrin:
 

Forum statistics

Threads
1,215,555
Messages
6,125,490
Members
449,234
Latest member
slzaleski

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