Excel - display message when missing file reference is found

%3CLINGO-SUB%20id%3D%22lingo-sub-832665%22%20slang%3D%22en-US%22%3EExcel%20-%20display%20message%20when%20missing%20file%20reference%20is%20found%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-832665%22%20slang%3D%22en-US%22%3E%3CP%3EI%20can't%20seem%20to%20get%20this%20right.%20I%20have%20a%20client%20with%2010000's%20physical%20files%2C%20listed%20in%20Excel%2C%20to%20which%20I%20need%20to%20apply%20barcodes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20amongst%20these%20are%20approx%202000%20files%20that%20should%20already%20have%20a%20barcode%20attached%20but%20I%20know%20won't.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20I%20need%20to%20somehow%20configure%20Excel%20to%20display%20a%20message%20when%20one%20of%20the%202000%20is%20found%20so%20we%20know%20to%20check%20our%20other%20DB.%20Hope%20this%20makes%20sense.%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-832665%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I can't seem to get this right. I have a client with 10000's physical files, listed in Excel, to which I need to apply barcodes.

 

However, amongst these are approx 2000 files that should already have a barcode attached but I know won't.

 

So, I need to somehow configure Excel to display a message when one of the 2000 is found so we know to check our other DB. Hope this makes sense.    

1 Reply
Highlighted

Do you need help on a query? @Neil2177