Compile one pricelist out of 20 Workbooks

[Barryvdw]

Here is my challenge.

I receive about 20 pricelists from various computer suppliers with component pricing.

I would like to compile one pricelist out of all of them.

The challenge is however that that the sheets are not formated the same.

Some suppliers go: ItemCode| Price | Description

Others might be: Itemcode | Description | Price

I know you clever people know what I mean so please provide any suggestions or ideas.

 

[JLGWhiz]

Here is my challenge.

I receive about 20 pricelists from various computer suppliers with component pricing.

I would like to compile one pricelist out of all of them.

The challenge is however that that the sheets are not formated the same.

Some suppliers go: ItemCode| Price | Description

Others might be: Itemcode | Description | Price

I know you clever people know what I mean so please provide any suggestions or ideas.

Would you want to share information on the media used by the vendors to provide you with their price list and if it has been down/up loaded to Excel. Kind of difficult to see that from this distance. (chuckle)

 

[JLGWhiz]

The first effort will likely have to be a manual reorganization of the data for each vendor. It would seem logical to pick the most common elements of data between all vendors, such as part number, item name, color, size, material composition, etc. Whatever the essential characteristics are that the item is ordered by if the part number is not item specific. If the part number is item specific it can save a lot of grief in handling the descriptive data. Then of course you have the price breaks, which will vary between vendors, but can probably be handled with a generic quantity progression chart. in 100, 200, 500 increments, whatever review of the price lists dictate. Onec a common format is established for each vendor and the data rearranged within the workbook, with the key data elements all being in the same columns within each workbook, then you can think automation.