Excel 2007 Price Change Comparison

Microsoft Microsoft excel 2007 full vers...
December 23, 2010 at 08:28:37
Specs: Windows XP
Excel 2007. I want to be able to create a master price list (Column B, row by row = product by product). Then, when we get a new shipment/invoice, I want to be able to pull the corresponding data into the excel workbook, COMPARE the price changes (IF they changed) and if possible send that data to a new column or at least highlight only the changes. Is that a possible simple function, not getting into sql or access or vb or anything?

Example: Original Price List Column A = name (will not change) Column B = price (B1 = $1.00, B2 = $2.00)

New price list (new workbook? or new sheet?) shows Column A stays the same but B1 is now $1.25, and B2 has not changed.

Is there a way to highlight B1 so I can notice the changes immediately?

Or better yet is there a way to copy/dump that changed price into another column (for example, have Column C row C1 show $1.25 (price changed) but show nothing for C2 which did not change?

Thanks help is appreciated.

edited by moderator: email address edited out

See More: Excel 2007 Price Change Comparison

December 23, 2010 at 09:17:03
Never post your email address in plain text in a public forum.

We don't really care if you get a lot of spam, but we don't want this forum to be known as a place where email addresses can be harvested. That just opens us up to all sorts of security issues.

Office Forum Moderator

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

December 23, 2010 at 09:38:21
sorry i should know better

Report •
Related Solutions

Ask Question