MrExcel Publishing
Your One Stop for Excel Tips & Solutions

MrExcel News


Next Invoice Number

Next Invoice Number »


Microsoft Excel offers many invoice templates that you can download. But there is no built-in way to increment to the next invoice number.

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.