im supposed to write something for work and i have just started this.
we have spreadsheets with part numbers, and how many we have for eac
one. after each total we have how many people want to buy. right no
we just do the math manually. heres an example:

in cell b2 is the total number of parts we have, say its 300. afte
that in c2 to like t2 we have buyers with an amount they want.
subtract each from the total we have. so we start out like this, d2
c2 , e2 - d2. adn we keep subtracting what the buyers want from what w
have in stock until we dont have anything left. when we run out, w
know who we need to ship to , and who is oging to be waiting till w
make new parts. so basically subtract what each buyers wants from th
total we have till it hits a negative number, the last positive number
is the last date we will be shipping out the parts. and we have lik
300 of these. im supposed to write something to automatically subtrc
all these numbers of the buyers from the total parts we have. anyon
understand? its basically subtraction down the spreadsheet. until i
hits a negative. but it has to do it in each row. and theres like 30
rows. so manually takes hours, if we could write soemthing to do it fo
us, that would help. anyone have a clue? im not asking anyone to rit
it for me, but can someone kinda help me on my way? cause im still s
new. and stuck. any suggestions will help,. i appreciate it.

-dere

--
Message posted from http://www.ExcelForum.com