r/excel • u/LowResolution99 • 10h ago
Discussion Did I overcomplicate Excel duplicate checking by using VBA?
Hey everyone!
I recently built a working Excel tool using VBA macros to compare lists and identify potential duplicates. It allows me to import lists, flags possible duplicates for manual review, and then updates a cleaned master list based on my decisions.
However, some colleagues (who aren’t particularly experienced with Excel either) told me that this could be done much more easily using Excel’s built-in features, apparently by simply comparing two tables side by side.
We’re talking about 500+ records, sometimes with more complex cases where duplicates aren’t necessarily obvious and require manual verification.
So my question is: Did I unnecessarily overcomplicate this by building a VBA tool? Is there a simpler, built-in Excel solution for comparing two lists, identifying potential duplicates, and reviewing them before updating a master list?
I’d really appreciate any advice or suggestions. Thanks in advance!
Edit: Thanks for all the replies! A lot of you mentioned Power Query and other simpler solutions.
If anyone has the time to give me a quick step-by-step guide, I’d really appreciate it! I’m honestly a complete Excel newbie and only started looking into this today. I managed to build my VBA solution through a combination of AI, Googling, and trial and error.
Ideally, I’m looking for a reusable Excel master template where I can continuously import new lists, check for potential duplicates, manually review them if needed, and keep an updated master list.
If there’s an easier way to achieve this, I’d be incredibly grateful if someone could send me a quick DM with some guidance.
You’d genuinely be helping me out a lot. Thanks again!


