PivotPal started as a simple form with a search box where you could quickly find a field in the field list, then add it to one of the areas in the pivot using keyboard shortcuts. This is where the PivotPal add-in was born. However, I wanted to bring these automation routines into an application that everyone could use. Over the years I have written a lot of macros that perform specific tasks to modify or update a pivot table. There are certain tasks that just take way too much time with the built-in field list and various options menus.įortunately, VBA (the language used to write macros) allows us to program pivot tables to help automate some of these tasks. When you start using pivot tables frequently, you begin to realize that some of Excel's built-in tools could be a little more efficient. They have a seemingly infinite number of uses, and they are just awesome! I use pivot tables for everything from a quick list of unique values, to reconciling accounts, to creating sophisticated interactive dashboards. I love Excel! □Īnd, I have probably built thousands of pivot tables. My name is Jon, and I have been using Excel all day everyday for over 10 years. This process alone can be very time consuming. REPEAT for all the fields you want to add.Go back to the sheet that contains the pivot table.Scroll horizontally through the columns until you find the field.Find the sheet that contains the source data.If you have pivot tables with more than 20-30 fields, then just scrolling through the field list to find the field you're looking for can take a lot of time.Īnd if you don't know the name of the field you are looking for, then you probably do something like the following: If you use pivot tables frequently then you could be wasting a lot of time with some of these boring repetitive tasks, which takes time away from the fun stuff. These small tasks can be very time consuming and frustrating!ĭo You Spend Extra Time Building Pivot Tables? Do you spend extra time doing any of the following? However, we also spend a lot of time doing repetitive tasks with pivot tables. There is no doubt that pivot tables are incredibly powerful, and save us a lot of time when summarizing data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |