Delete Duplicate Cells in Excel Across Tabs
Trying to figure out how to delete duplicate cells in excel across tabs.
Ie. For a keyword “Fish Burger Deluxe” in tab “Tomato”, search all the other tabs in the workbook and delete the keyword “Fish Burger Deluxe” in all other tabs, except tab “Tomato”

First, to organize the keywords into one location (Cell “AA”) and show which tabs had duplicates, and how many, I used this YouTube video as a guide.
Entire Task Broken Down into Individual Actions (With Links To Guides):
- Select cell – (“Fish Burger Deluxe”)
- Copy cell data into variable (Define as a variable)
- Go to next tab
- Or search copied data across other tabs
- Resource 1: VBA: Using a Find-like function across all workbook sheets without looping
- Resource 2: Find data in specific cells in multiple worksheets using VBA
- Resource 3: Referring to other worksheets or workbooks in an excel macro
- Resource 4: VBA Find function not working with variable
- Or search copied data across other tabs
- Search that tab for copied data
- Delete entire row (Or individual cell with keyword “Fish Burger Deluxe”, whichever is easier)
- Repeat Step 3 until all tabs have been searched (besides first tab that contains keyword, “Tomato” in this case) and duplicates have been deleted
Resources:
Link to thread on this problem on Stackoverflow.com