hi guys
my name is shakeel,i am working as a store keeper in manufacturing company.i want to build stock card inventory system.for example a work book contain diffrent shhets and these sheets are consider to be a stock card consistent with a data opning balance,purchased and issued quantity and balance each day transaction.
now i want to make a data entry form where from i can put tha data as purchased, issued.in this form there will be a table of item.i will select the items either purchased or issued.
if i ll press the purchase button the selected item in the form will show the effect in each of the stock card automatically and vis versa same with issued it ll b detected the quantity from the selected item stok card

can anyone tell me how can i make this in the excel 2007

thank you very much