Hello all,
I am making inventory control for literatures. I need your help. kindly give me ideas/advice how to create it.
i have made 3 sheets:-
1) for item list in this sheet i have
a1: Particulars, b1: Item, c1: Group, d1: Code and e1: Opening Balance
2) for Data entry in this sheet i have
A1: Date, b1: Month, c1: Year, d1, Item Sent, e1: Reference, f1: sent to
g1: opening balance, h1: sent, i1: received, j1: Balance, k1: Remarks
3) for summary of literatures sent
in a1: Item, a2: year, a3: month, a4:date
I want to work with sheet2 (data entry) in which i only want to write sent, receive quantity and remarks other fields are set to list (data validation) from sheet1.
in last i want a whole month summary at sheet3 as i have 3 lookup values.
in summary dated, opening balance, sent to, sent, received, balance, remarks.. and i also having problems in opening balance and closing balance that will update at end of every month. kindly give me ideas and suggestions how to create my inventory control.
I am making inventory control for literatures. I need your help. kindly give me ideas/advice how to create it.
i have made 3 sheets:-
1) for item list in this sheet i have
a1: Particulars, b1: Item, c1: Group, d1: Code and e1: Opening Balance
2) for Data entry in this sheet i have
A1: Date, b1: Month, c1: Year, d1, Item Sent, e1: Reference, f1: sent to
g1: opening balance, h1: sent, i1: received, j1: Balance, k1: Remarks
3) for summary of literatures sent
in a1: Item, a2: year, a3: month, a4:date
I want to work with sheet2 (data entry) in which i only want to write sent, receive quantity and remarks other fields are set to list (data validation) from sheet1.
in last i want a whole month summary at sheet3 as i have 3 lookup values.
in summary dated, opening balance, sent to, sent, received, balance, remarks.. and i also having problems in opening balance and closing balance that will update at end of every month. kindly give me ideas and suggestions how to create my inventory control.
