Duplicate Finder in Excel

I want a reusable, push-button way to scan any Excel file and surface duplicates without manually filtering or scrolling. The workbook size can vary from a single column list to a multi-sheet dataset, so the solution needs to be flexible:

• Detect exact, partial and even “fuzzy” matches when I switch the setting.
• Let me choose whether to review highlighted rows, move them to a separate tab or delete them entirely.
• Work across a selected range, specific columns, or the whole sheet as I specify each time.

A VBA macro, an add-in, or a Power Query template are all acceptable—as long as it runs inside standard desktop Excel (365 and 2019). Please include a brief user guide inside the file and keep the code unlocked so I can adjust thresholds or column selections later.

Acceptance criteria:
1. One-click launch from the ribbon or a clearly labeled button.
2. Prompts that let me pick the scope (range, columns, full sheet) and the action (highlight, move, delete).
3. Accurate results verified on a sample file I will supply.
4. Clear comments in the code or steps in Power Query explaining the logic.

If you have an existing tool that meets these points, great—otherwise I’m happy to see a custom build.