I have a master worksheet (WS1), and a new worksheet (WS2) with updated
pricing on about 3K items. I need to put the new pricing from WS2 for each
item into WS1. Not all items have new pricing, so if there is no change, or
the item isn't even listed in WS2, then I need the old price to be left as it
is. I am only concerned with 2 columns of data, Column A being product #,
and Column B being Price.
Simply put, I want excel to look at product A on WS2, and if that product is
on WS1, then I want to update WS1 with the new price.
It would also be very nice if when product A on WS2 was not recognized it
was highlighted or put into a new column or something, since I will need to
add those new items eventually. But most important I need to update pricing
on these items.

--
Louis