Not sure if I have the right forum here, so sorry if this should go somewhere else.

I am not sure how to program a macro to search for a cell if that cell is a text cell, ie if the cell 00-DIV-00443 (a barcode)

The hope is to move towards autoreporting. The user inputs the barcode at the start of the process and the macro runs and pulls back the data that corresponds to that barcode from access.

I have attached a folder Data Pull.zip with a pretty Explanatory excel file and a database to practice on. The real database is much larger than the one in the folder but the code should be the same.

Any help would be appreciated.

Stephen