S
stiv
Guest
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
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
