Kimberlee MartinDec 22, 20223 minUsing Access to Clean Excel Data, Part 5I’ve been covering the use of Microsoft Access tools to clean your Excel data for the past few weeks. Today is the final entry in that...
Kimberlee MartinDec 19, 20224 minDoubles, but No TroublesUse VBA to check for nearly identical data in your Excel worksheet.
Kimberlee MartinDec 12, 20226 minUsing Access to Clean Excel Data, Part 4Use MS Access to find duplicates in your Excel data
Kimberlee MartinDec 6, 20222 minAuto-replace Text in Excel Cell with VBAIn recent posts, I’ve been talking about validating your Excel data using VBA. I talked about creating a validation harness, which you...