I'm entering the home stretch in my project, and the last piece is to tie the various figures together.
On my master sheet, I have my starting stock for products A and B for each customer and "today's count" which is calculated from here:
=SUM(F2+DAILY!$AF2+DAILY!$AF3+DAILY!$AF5+SUM(HISTORICAL!$F2:HISTORICAL!$BO3,HISTORICAL!$F5:$BO5))
This formula takes the starting stock, current regular and custom orders and new stock, historical regular and custom orders and new stock, adds
them all together and reports what we would currently have. Product B is calculated in a similar manner:
=SUM(F3+DAILY!$AF3+DAILY!$AF4+DAILY!$AF6+SUM(HISTORICAL!$F3:HISTORICAL!$BO3,HISTORICAL!$F6:$BO6))
The second customer's formula would be this for product A:
=SUM(F4+DAILY!$AF8+DAILY!$AF9+DAILY!$AF11+SUM(HISTORICAL!$F8:HISTORICAL!$BO9,HISTORICAL!$F11:$BO11))
Product B would be
=SUM(F5+DAILY!$AF10+DAILY!$AF12,HISTORICAL!$F10:HISTORICAL!$BO10,HISTORICAL!$F12:HISTORICAL!$BO12)
From what i've been able to learn so far (which is just enough to get in trouble :P) an array should help, but i don't really understand how to use them for something like this....
Bookmarks