on sheet1 i have a list of items in col a and in col b i enter the qty
of those items on a daily basis ex.

........a..............................b.......... ...............
beef................................3............. ......
cod..................................1
chicken............................24

col b is different every day

on sheet 2 i have a list of days in col a col b would be beef col c
would be cod and col d would be chicken ex....

..........a..........................b............ .............c...................d................ ..
...................................beef........... .........cod.................chicken
8/14/05
8/15/05
8/16/05

if today is the 14th i need col b to enter the number for beef on sheet
1 same for cod ect... than tommarow when i change those #'s on sheet1 i
need the 14th's # to stay and the new # to go to the 15th keeping a
daily log of those #'s

is this posible please 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=395696