by John MacDougall | May 20, 2017 | Tips
Microsoft Excel has just released a cool new add-in called Transform Data by Example to help make cleaning and transforming data easier. This add-in will allow you to quickly standardize time and dates, names, postal addresses, email addresses and much more!...
by John MacDougall | May 7, 2017 | VBA
Something that comes up time and time again in any kind of work is separating data out into separate workbooks based on the values of a field in the data. Download Example Files Let’s say you have sales data for your company and you need to send each of the...