Hi, my excel skills aren't all that great and i really need some help with this otherwise i think i may have to go through manually which could take hours!
I have a database for a warehouse full of boxes, there are 12 sheets corresponding to different aisles in the warehouse, each with around 3000 box numbers in their specific locations.
i also have 1 sheet which has a list of 2000 boxes i have to remove from the warehouse.
is there a way (without moving everything to 1 page) that i can highlight all the duplicate numbers in their current sheets so it's easier to locate those boxes that need to be destroyed?
Thanks, josh.
Bookmarks