Hello,
I want to work with macro;
sheet1=master,sheet2="x" item,sheet3="y"item. In master,cell A1 input with code item and A2 input with quantity.
if current date 2009/1/1, and I Type "x" in A1 and "100" in A2(sheet1), the value is copied to C1 is "100" in sheet2( sheet "x')
if current date 2009/1/2, and I Type "x" in A1 and "200" in A2(sheet1), the value is copied to C2 is "200" in sheet2( sheet "x')

Thanks in advance for your kind guidance.