R
reverend-x
Hi guys
I'm creating a stock control system as part of a project that I shoul
have done a long time ago.. and now that it's came to crunch time I'v
realised I don't know what the hell i'm doing. I've pretty much gott
have this done by friday
Basically what I want to do with my system is:
a) Add items of stock to a list
b) Create a 'sales' function that deducts the amount of stock and add
to the number of 'sales'
c) A function that stores the date of the sale on a seperate sheet
d) A function that averages out the number of sales then automaticall
adds the item to an order form sheet if it is 'popular'.
I've achieved A and B ... C and D are prooving to be difficult :\
I've attached my system below... if anyone could help I will b
eternally in your debt and love you forever
Thanks in advance!
Andre
Attachment filename: system.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=46054
I'm creating a stock control system as part of a project that I shoul
have done a long time ago.. and now that it's came to crunch time I'v
realised I don't know what the hell i'm doing. I've pretty much gott
have this done by friday
Basically what I want to do with my system is:
a) Add items of stock to a list
b) Create a 'sales' function that deducts the amount of stock and add
to the number of 'sales'
c) A function that stores the date of the sale on a seperate sheet
d) A function that averages out the number of sales then automaticall
adds the item to an order form sheet if it is 'popular'.
I've achieved A and B ... C and D are prooving to be difficult :\
I've attached my system below... if anyone could help I will b
eternally in your debt and love you forever
Thanks in advance!
Andre
Attachment filename: system.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=46054