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