Related:
- Creating an order list from a sales sheet
- Windows network commands cheat sheet - Guide
- Google sheet right to left - Guide
- Counter strike 1.6 cheats list - Guide
- All contact number list with name - Guide
- How to change your best friends list on snapchat to 3 - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Dec 18, 2015 at 10:54 AM
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