How to remove leading spaces from Excel cells?
Leading spaces can cause major issues with automated reports and Excel lookups as values that might have been set previously no longer match what is in the data. Imagine if… Read more »
Monthly Archives: September 2016
VBA Code – To split an Excel PIVOT Table into Multiple Reports
PIVOT tables are a great way to summarize data but sometimes it is important to be able to split a PIVOT table out, generating multiple reports based off all the… Read more »
Two cents’ worth to get your VBA code to run faster
Today I am going to discuss simple ways to write the VB programming in the most efficient manner to, optimize the VBA code saving a lot of time for the… Read more »
How To Use VBA Code From The Internet
So you’ve found some VBA code on the internet that will save you hours and hours of work, but how do you get it into Excel and use it? Often… Read more »