data entry on certin dates

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???

See reply in .Misc

Biff

"n0 h4ck1ng" <[email protected]> wrote
in message news:[email protected]...
>
> 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???
>
>
> --
> n0 h4ck1ng
> ------------------------------------------------------------------------
> n0 h4ck1ng's Profile:
> http://www.excelforum.com/member.php...o&userid=18410
> View this thread: http://www.excelforum.com/showthread...hreadid=395704
>