Previous Topic Next Topic

Creating an order list from a sales sheet

Closed
Aytac - 18 Dec 2015 à 07:15
 Aytaccemal - 18 Dec 2015 à 20:58
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 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
18 Dec 2015 à 10:54
I thought you said the sheet is already auto updated.
Aytaccemal Posts 2 Registration date Friday 18 December 2015 Status Member Last seen 18 December 2015
18 Dec 2015 à 11:16
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
18 Dec 2015 à 18:51
So, you need a history lookup, or parts ordered specific to customer?
Aytaccemal Posts 2 Registration date Friday 18 December 2015 Status Member Last seen 18 December 2015
18 Dec 2015 à 19:08
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
18 Dec 2015 à 20:41
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?
Aytaccemal > Blocked Profile
18 Dec 2015 à 20:58
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.

Similar discussions

Facebook Messenger - Suggested Friends
jadess_0462 -
Akajackal -

2 responses
Snapchat block list
Jasonve -
dwebb -

1 response
Blocked account list shuffled without me unblocking or blocking
Besmir85 -
Ec92 -

6 responses
Blocked List Shuffled Instagram
asapyj -
HelpiOS -

1 response
Anyone's dm order all weird ?
Tillyleon111 -
toogleeful -

2 responses