Get our FREE VBA eBook of the 30 most useful Excel VBA macros. Automate Excel so that you can save time and stop doing the jobs a trained monkey could do. Claim your free eBook Recent Blog Posts When you should merge cells in Excel – 3 scenarios How to make cross filter visuals in Excel (amazing interactive visuals) Power Query: Rename columns in nested tables from list (without errors) How to create Multiple PDFs from Excel (Office Scripts + Power Automate) How to add fiscal Month, Quarter or Year Column in Power Query Power Query: How to multiple replace values based on a list How to transform nested tables in Power Query (without coding) How to Find & Replace multiple words in Excel: REDUCE & SUBSTITUTE How to make an interactive view-only dashboard from Excel Power Query: How to Combine files based on a list How to create dynamic text in Excel (TEXT + Number Formats) How to make Waffle Charts in Excel that work EVERYWHERE!