I have an inventory list online that is constantly updated. What I need
to do is check and see which new products have been added and old
products that have been discontinued. Could I merge the old inv. with
the new and run a macro or a Comparison phrase with multiple conditions
that would maybe identify with cell shading or font color the new
inventory that has been added and the old that has been removed. An
easy way to identify the products is by column A which is the mfr_code.


ex. of the mfr_code in column A
ACO-APO30
ACO-MS1/8
AMB-V4801
GEM-GH3910
ect....

Maybe, I could use the Match function with comparing sheets I could use
another column or the same column with conditional formating to color
the cells as an indicator to show which products have been added and a
different cell color for the ones that have been discontinued or a
macro that would do something similiar.

Thank you for your time,

Greg


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/