Creating an order list from a sales sheet

[Closed]
Report
-
 Aytaccemal -
Hello,

I am working of an excel sheet which is updated every time a sale is made. what i would like to do is have a list auto populated which would show all of the items and suppliers that we would need to make an order from? so for example

I have sold 3 x model kits from supplier A, 2 x boats from supplier B and 12 tool kits from supplier C. i would like this to be auto populated in a sheet everytime an order is made to help streamline our ordering process.



is this possible?


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
I thought you said the sheet is already auto updated.
Posts
2
Registration date
Friday December 18, 2015
Status
Member
Last seen
December 18, 2015

Hi rizvisa1,

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?
Blocked Profile
So, you need a history lookup, or parts ordered specific to customer?
Posts
2
Registration date
Friday December 18, 2015
Status
Member
Last seen
December 18, 2015

HI Ac3mark,

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?
Blocked Profile
Well, make sense, yes and no.

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?
> Blocked Profile
A sales is done by phone or email. But is manually entered on to the excel sheet. The whole row is marked blue until the product has been shipped to the customer.