M
Mike
Hi,
I'm working on a spreadsheet whereby a list of engine parts are listed along
with quantities in stock - basically a stock check.
I have formulas in place and conditional formatting to show which items need
to be reordered - is there any way to automatically create another sheet that
will list all items that need to be re-ordered, along with part numbers etc
and minimum order quantities?
Basically, instead of me typing out from a very long list which items i need
to reorder, i'd like the spreadsheet to list the items based on a
differential between current stock and minimum stock quantities.
Thanks in advance.
I'm working on a spreadsheet whereby a list of engine parts are listed along
with quantities in stock - basically a stock check.
I have formulas in place and conditional formatting to show which items need
to be reordered - is there any way to automatically create another sheet that
will list all items that need to be re-ordered, along with part numbers etc
and minimum order quantities?
Basically, instead of me typing out from a very long list which items i need
to reorder, i'd like the spreadsheet to list the items based on a
differential between current stock and minimum stock quantities.
Thanks in advance.