Excel Data Cleaning Automation

I have several raw spreadsheets that need to be transformed into a clean, consistently formatted dataset and then wired for hands-free data entry. The first phase is all about hygiene: every duplicate record has to disappear and every cell must follow a single, tidy format so downstream formulas behave predictably. After that, I want a lightweight macro (or small VBA routine, if you prefer) that lets me paste or import new rows and have the workbook handle the placement, validations, and basic calculations automatically.

Core requirements
• Remove every duplicate across all key columns without touching unique entries
• Repair inconsistent date, number, and text formats so the file is ready for formula work
• Build an automated data-entry macro that drops new information into the right table, triggers validations, and updates running totals instantly

I already use functions like VLOOKUP, IF, SUM, and COUNT, so feel free to lean on those for internal checks. A brief comment block inside the VBA explaining each step will help me tweak it later, and a short test dataset that proves everything runs error-free will close the loop.

If you love clean sheets that stay clean and enjoy writing no-fuss automation, this should be a quick, satisfying win for both of us.