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 ...

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.

This repository contains a curated set of Excel VBA macros, organized as .bas code modules for easy reuse and import into any Excel workbook. These macros are designed for: Data cleaning and ...

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 ...