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
