Related:
- Creating an order list from a sales sheet
- How to create drop down list in excel - Guide
- How to create a formula in excel for multiple sheets - Guide
- How to create a broadcast list on snapchat - Guide
- EXCEL - Create a bulleted list in a single cell from a list ✓ - Forum - Excel
- How to create a row list according with dates ✓ - Forum - Office Software
1 reply
rizvisa1
Dec 18, 2015 at 10:54 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Dec 18, 2015 at 10:54 AM
I thought you said the sheet is already auto updated.
Dec 18, 2015 at 11:16 AM
we manually add each sale to an excel sheet. but what we want is to create a list on another tab which updates the items needed to be ordered. so the 1st tab would have all over our sales for the month but the 2nd tab would show the list of items which need to be ordered and not completed. we would currently set these items to show o/s on the 1st tab if that helps with what we want to create?
Dec 18, 2015 at 06:51 PM
Dec 18, 2015 at 07:08 PM
well the sales sheet is a continuous list. so every time we get an order we add to it. if it is in stock we mark the line white. if it needs to be order then its blue and out standing
what i want is that everything that's outstanding to populate in another sheet putting the info we need to follow up on those order.
make sense?
Dec 18, 2015 at 08:41 PM
What I mean by that is, how are these sales being entered: By electronic form, or manual entry into a spreadsheet?
So what qualifies a sale, and a marking of blue? When does this qualification take place?
Dec 18, 2015 at 08:58 PM