Inventory Duplicates - Highlight across multiple worksheets

March 8, 2017 at 11:16:46
Specs: Windows 10
I have a list of all serial numbers in our inventory. This list is on sheet 1, column C.

I need sheet 2, column A to highlight if it is a duplicate of sheet 1, column C.

Basically, the end result would be every serial number not highlighted was not scanned during inventory.

I need the highlighting to be done in real time meaning my team does not have to hit any button to "refresh" the highlights.


See More: Inventory Duplicates - Highlight across multiple worksheets

Report •

#1
March 8, 2017 at 11:27:24
Thanks for letting us know what you need.

If you'd like some help with that, feel free to ask.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
March 8, 2017 at 11:30:26
I would like to know how to highlight the duplicate values across multiple worksheets.

Report •
Related Solutions


Ask Question