I have 2 workbooks that will be needed for this macro.

One is a simple list: column A = product code, column B = product
name

The second workbook is a forumula for our products, which uses only
product code so no one can get our formulas and take them.

Before we print this for internal use, we would like to convert the
product code to the product name by running a macro.

For example, I would like to search the formula workbook for the
product code and replace it with the product name. There are over 200
products, so doing a macro where I recorded replacing these
individually would take forever. Also, some of the product code are
very similar.. ie. VRM2004 VRM2004A VRM2004B. Obviously if you
search for VRM2004 it would change all of those, so it needs to be an
exact match with the product code in the first sheet.

Please help.


--
richinlaf31
------------------------------------------------------------------------
richinlaf31's Profile: http://www.excelforum.com/member.php...o&userid=25846
View this thread: http://www.excelforum.com/showthread...hreadid=392302