Good Morning.
I am a bar manager and am looking to make my ordering easier. My predecessor made a workbook that has sheets for each month. I only have enough experience with excel to add what was received (IN) and what was used (OUT) each week, there are formulas to change my "on hand" and "to order" counts. I would like, when the "To Order" column is greater than 0, to have those rows copied to a new sheet and sorted by "where". I only need the name of the liquor, from and to order columns on the new sheet unless the entire row copied is better.
TIA, if a macro is more appropriate than a formula, let me know and I'll post this there.
Bookmarks