I have two spreadsheets that contain item #, descriptions, and costs. One is
from 1008 and the other is for 2009. There are 2460 rows of information in
the 2008 and 3586 rows of information. I need to compare the 2 sheets and if
the part # exists in 2009 then change the cost pricing in 2008 to newest
cost. Also there are obviously 1186 new item # in the 2009 sheet, is there a
way to have them separated if they don't match the 2008 so they can then be
added at a later time?