Iventory List Help

[xobile]

Hi ALL,

Every week I receive an Inventory list. It contains four columns: Part Number, Price, Quantity, and Total. After I receive the Inventory List, I go through every Part Number and add their Product Name. I may be going this the wrong way but I have created a macro that I have saved in my Personal Workbook that copies all the part number to a different column and then uses a replace function to replace all the part number to its product name. The problem is, every month I would have to update the macro when I have new part numbers. I thought of making a spreadsheet with all the Part number and Product name adjacent to each other and make a macro that uses a Vlookup to look at different workbook. Note: The list has over a thousand items.
My question is: What do you think is the best way to approach this? Or am I over thinking this?

Thank you

Before

Excel 2007
	A	B	C	D	E
4	Item Number	Price	Quantity		Total
5	12345	$ 2.00	8		$ 16.00
6	12344	$ 15.00	4		$ 60.00
7	25533	$ 7.00	5		$ 35.00
8	53536	$ 10.00	9		$ 90.00
Sheet1

Cell Formulas
Range	Formula
E5	=B5*C5
E6	=B6*C6
E7	=B7*C7
E8	=B8*C8

After

Excel 2007
	A	B	C	D	E
4	Item Number	Price	Quantity	Product Name	Total
5	12345	$ 2.00	8	Blue Pen	$ 16.00
6	12344	$ 15.00	4	Red Pen	$ 60.00
7	25533	$ 7.00	5	Black Pen	$ 35.00
8	53536	$ 10.00	9	Green Pen	$ 90.00
Sheet1

Cell Formulas
Range	Formula
E5	=B5*C5
E6	=B6*C6
E7	=B7*C7
E8	=B8*C8

 

[kyleball]

If you want the product name to populate from the item number you will always need an up-to-date sheet with the part number and product name. That is unavoiable; Excel can do some pretty amazing things but it still needs the base informatin there.

What I would think would me most simple:

A master sheet with all the item numbers and product names, then a simple vlookup.

It does not need overcomplication from Macros.