4 Ways to Remove Unwanted Space Characters
Learn how to remove unwanted space characters from text data in Excel using various methods.
Read More
Category: VBA
How To Automate Sorting, Hiding, Unhiding and Listing Your Sheets
It’s often the case that workbooks get very large and end up with a lot of sheets. Excel...
Read More
How to Create Delete and Rename Folders from a List
I started making videos to go along with my post on pivot tables called 101 Advanced Pivot Table...
Read More
How To Export Your Data Into Separate Workbooks Based On The Values In A Column
Something that comes up time and time again in any kind of work is separating data out into...
Read More
How To Check If A Worksheet Exists Using VBA
There may come a time when you need to know if a sheet in a workbook exists either during VBA code...
Read More
How To Find The Nth Item In A Comma Separated List
Let’s say you have a column of data and in each cell you have a text string which is a list...
Read More
How To Add A Form Control Button To Run Your VBA Code
If you have a workbook that uses some VBA code and you want an easy way for someone to run the...
Read More
How To Create A Dynamic Worksheet Selection Popup Menu
If you have a workbook with a lot of sheets, then navigating through them can be a pain. This tip...
Read More
Consulting
Newsletter
Excel Functions eBook
Microsoft MVP
Recent Posts
Newsletter