Hello
I am working on an inventory project at school. I have calculated re order points for thousands of items in a warehouse. I want to be able to change the quantities for current inventory (column B in my attached example) and when the levels reach the re order point (column C in my attached example) I want excel to add those items to another sheet perhaps that list all items that have hit their re order point.
Please let me know if you can help.
Thanks
Bookmarks