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.

Microsoft Excel is arguably the greatest spreadsheet application from Redmond, and there’s a good reason so many number crunchers use it for all of their number crunching needs. While using Microsoft ...

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