You should be able to query the database to match a group of in-hous
codes to equivalent standard codes. (I'm assuming you need to do tha
as a first step because the rest of the data is organized according t
the standard codes.) Running a database query from Excel is relativel
easy. You can work with the results directly in a recordset or dum
onto a sheet.

Bil

--
Bill_excelforu
-----------------------------------------------------------------------
Bill_excelforum's Profile: http://www.excelforum.com/member.php...fo&userid=3228
View this thread: http://www.excelforum.com/showthread.php?threadid=52610