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.