A VBA program which creates several filtered pivot tables from a large data pull. Used to create pivot tables of weekly withheld tax amounts from a large data pull. Storing in GitHub as it has a VBA ...

The pivot table is arguably Excel's most powerful tool. It can summarize so much data in so little time with no more than a few clicks and drags. But creating and controlling one using VBA is a ...

Editor’s Note: To read more about spreadsheets, share a tip with other readers, or suggest a topic for Bill Jelen to cover in an upcoming column, click here to visit CFO.com’s Spreadsheet Tips Page.

I have a pivot table in Excel 2003, which contains a dropdown list in the table header that is based on a column of dates. If the underlying table of dates is first populated out of order then the ...

Have you ever found yourself staring at a sprawling Excel workbook, wondering if you’re using the right tool for the job? Between Power Query, Power Pivot, and VBA, it’s easy to feel like you’re ...