G
Guest
Guest
Im doing a Major skool project for my A levels and (this project needs to b an A grade 
) I and the rest realllllllllllly need this problem solved bcos were all doin a Stock control system. When a Sale is entered in the Sale workbook how do I get the sale quantity entered to subtract from the Stock quantity in the stock workbook automatically when its entered? i was thinkin something like Vlookuup n IF state ments!>????> :S
) I and the rest realllllllllllly need this problem solved bcos were all doin a Stock control system. When a Sale is entered in the Sale workbook how do I get the sale quantity entered to subtract from the Stock quantity in the stock workbook automatically when its entered? i was thinkin something like Vlookuup n IF state ments!>????> :S
