cell input on certian dates!!
 

Ok, heres my question.

on sheet2 i have a list of items in col A that i inventory daily, in
col B i enter those qtys.

ex.

A B
Beef 3


On Sheet1 in col A i have the dates for the month


A B
8/4/2005
8/5/2005
8/6/2005

i need sheet1 col b to lookup and input the number from sheet 2 col b
on the spacific date that i am entering it but i need that number to
stay there when i change the number the next day.

i know its kind of vauge but i am new at excel and could really use the
help!!!

thank you!!


--
n0 h4ck1ng
------------------------------------------------------------------------
n0 h4ck1ng's Profile: http://www.excelforum.com/member.php...o&userid=18410
View this thread: http://www.excelforum.com/showthread...hreadid=393159

In sheet 1, you have only one B column. Do you want to display the summary of
inventory there?
Please do make it clear.

"n0 h4ck1ng" wrote:


Ok, heres my question.

on sheet2 i have a list of items in col A that i inventory daily, in
col B i enter those qtys.

ex.

A B
Beef 3


On Sheet1 in col A i have the dates for the month


A B
8/4/2005
8/5/2005
8/6/2005

i need sheet1 col b to lookup and input the number from sheet 2 col b
on the spacific date that i am entering it but i need that number to
stay there when i change the number the next day.

i know its kind of vauge but i am new at excel and could really use the
help!!!

thank you!!


--
n0 h4ck1ng
------------------------------------------------------------------------
n0 h4ck1ng's Profile: http://www.excelforum.com/member.php...o&userid=18410
View this thread: http://www.excelforum.com/showthread...hreadid=393159