Hi
this is very similar to a lot of threads.
I have one sheet of consolidated serial numbers over numerous columns, each column has a date in row A and a name in row B, underneath is a list of serial numbers of assets that have been scanned to that person on that date.
I then get a list of serial numbers and I need to know if that serial has been scanned to an engineer and if so on what date.
I know a VBA can do this, but the ones I have found don't do the trick... I'm thinking that the VBA should search the consolidated spreadsheet and if it finds a duplicate it can either highlight the cell and I can then manually see who had it on what date, or the duplicate can be copied onto a 3rd sheet (column A), with the Name, (column B) and the Date (column C).
I can't use "find duplicates" conditionally formatting as other serial numbers may get scanned in and out various times during the month so I get highlighted serials that aren't on my query list.
Any help would be appreciated.
Bagpuss
Bookmarks