I want to be able to update pricing in a master worksheet from another
worksheet.



Ie: Master pricelist contains part numbers and pricing from HP, Microsoft,
IBM, etc (not necessarily in any order but all part numbers are in the same
column. This column also contains blank cells.). After copying the latest
downloaded pricelist from HP and other suppliers to separate worksheets in
the Master pricelist, I want to be able to have Excel automatically update
pricing from each of these worksheets based on the part numbers in the
Master worksheet part number column. I'd also like to be able to highlight
updated prices on the Master worksheet and also on the HP worksheet, etc.
This way I will easily be able to determine which part numbers on the Master
worksheet are no longer listed on the HP worksheet, and also new products on
the HP worksheet that are not yet listed on my Master worksheet.



I figure I will need to create some kind of Macro for each vendor/supplier
worksheet that I want to update to the Master worksheet. How do I do this?



Excel version is 2003 on Windows XP.



TIA


--
Kind Regards



Shane
SME IT Solutions
Email: mailto:[email protected]