updating data entry
hi guys,
I have a question regarding Excel I hope you'd
be able to help me out:
i'm working on inventory files,I have a receiving
spreadsheet and the main inventory.Is there any way to
update the quantity of the items in the main file when
I receive any new item:
RECEIVING FILE:
col. A col.B col.C
partA 20 2/2/07
partB 5 3/20/07
partC 10 3/25/07
partB 100 3/30/07
MAIN INVENTORY FILE
col.A (availability) colB(qty)
partA 1000
partB 100
partC 10000
I need col.B of main inventory file be updated
automatically
thanks in advance.
|