![]() To create an Excel PivotTable you need a range filled with data or a table. I then used this data as the basis of my pivot table. NOTE: I imported data from the OrderSummary query of the Northwind sample Access database. This code will help you relate to them and make their life easier. It’s quite likely your user base is 100% comprised of uber-serious spreadsheet jockeys. Today, I’ll show-off some code that shows how to automate pivot tables. ![]() They made my life easier and impressed my clients and my boss’s boss (but not my boss… he knew me too well). When I was a serious spreadsheet jockey trying to make my mark on the world (as a financial auditor for a super-serious accounting firm), I used pivot tables all the time… whether I needed to or not. ![]() Long before Big Data was even a twinkle in its mother's eye, there was Excel and its pivot tables. Microsoft Excel is the original business intelligence tool. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |