Dear helper,
With Excel i'd like to compare the stock of about 6000 different products from my supplier on a daily base (please see the attached file). I want to know the changes in the inventory (indicated by Yes, No or Low). Is it also possible to show newly added/removed products?
What is the best way to do this? If you need any additional information, please do not hesitate to ask.
Thank you,
Martijn
Kopie van Item_ENU.xlsx
Based on your note and assuming the values you are referencing (yes, no or low) are in col F (which actually has yes, out and low), it seems a filter on that column would work. But I suspect your request is deeper than that. If so you might need to elaborate more.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks