I have an inventory list online that is constantly updated. What I'm
looking to do is check and see which products are out of stock and
which have been added into stock this process happens twice a week. To
figure this out maybe would be a macro that could look at Column C
(items stock level) look and see any item with a 0 (out of stock) would
then take the mfr code (ex. ACO-AP1650) in column A and list it in
column B the products that are out of stock.

Column A ............ Column B.........Column C

ACO-AP1650.....................................5
FIS-43REJ............FIS-43REJ.............0
SAN-G34DD......................................2

Thank you for your time,

Greg


---
Message posted from http://www.ExcelForum.com/