EXCEL MACRO NEEDED - EASY

PLEASE DOWNLOAD THE EXCELL FILE, IT IS ALOT EASIER TO SEE WHAT WE NEED TO HAVE DONE. THE COLUMNS RUN TOGETHER IN THIS TEXT FORMAT!!!! YOU CAN WORK IT HAS ALL OF THIS INFORMATION. We need a macro that will convert an entire spread sheet to reference a manufactures part number not the “Product Page ID#”. We have over 20,000 SKU numbers. I am not a programer, but basically it would say: Find 15071 and convert to MFG#: 110-37 in the Accessories Column. Or Look at the acessories column, find the first number, go to Prod Page ID#, find the same number, look at the and convert it to the MFG PN. Our Accessories list references a Prod Page ID#, not the Manufactures PN. So we need to convert the products accessories to the manufactures actual product number. On line 3 MFG# 110-37 is a master product and the accessories that work with it are found on line 15 and 16. The problem is our file references the Page ID, not the MFG PN. You will see in the far column that we have converted the “Accessories” column to reference the Actual MFG PN. Here is how our file looks: 1 Prod Page ID# MFG PN Mfg Accessories – this does not work We need to make the “Accessories list look like this: 2 3 15071 110-37 MFG Name 17077|25007 117-19|117-09 4 25196 110-80 MFG Name 16296|25202|25211 117-41|123-26|116-25 5 25311 110-87 MFG Name 15462|31995 106-37|132-00 6 25197 110-79 MFG Name 17077|15462|31995 117-19|106-37|132-00 7 25198 116-15 MFG Name 25207|28004|28005 123-27|119-53|119-34 8 25200 110-81 MFG Name 30891|28116|28006 119-86|119-51|119-01 9 25199 110-69 MFG Name 15462|31995 106-37|132-00 10 16295 117-46 MFG Name 17077|15462|31995 117-19|106-37|132-00 11 25009 117-10 MFG Name 17077|15462|31995 117-19|106-37|132-00 12 16297 117-43 MFG Name 14620|25010|25210| 117-42|117-05|116-19 13 25203 116-23 MFG Name 17077|15462|31995|31539 117-19|106-37|132-00|B60-20-LOW-BL 14 15 17077 117-19 MFG Name 16 25007 117-09 MFG Name 17 16296 117-41 MFG Name 18 25202 123-26 MFG Name 19 25211 116-25 MFG Name 20 25212 116-21 MFG Name 21 25208 116-24 MFG Name 22 25210 116-19 MFG Name 23 25010 117-05 MFG Name 24 16420 117-42 MFG Name 25 25207 123-27 MFG Name 26 28004 119-53 MFG Name 27 28005 119-34 MFG Name 28 30891 119-86 MFG Name 29 28116 119-51 MFG Name 30 28006 119-01 MFG Name 31 30434 121-03 MFG Name 32 30433 121-06 MFG Name 33 30435 121-04 MFG Name 34 31539 B60-20-LOW-BL MFG Name 35 31995 132-00 MFG Name 36 15462 106-37 MFG Name