MrExcel Publishing
Your One Stop for Excel Tips & Solutions

MrExcel News

Split Workbook by Worksheets in Excel

Split Workbook by Worksheets in Excel »

You might have two reasons to want to split a workbook where each worksheet becomes a new workbook.

Sync Slicers in Excel

Sync Slicers in Excel »

How can you have a slicer drive two pivot tables if they came from different data sets? I recorded this video showing how to add a few lines of VBA code to your workbook to do this.