data entry on certin dates

  • Thread starter Thread starter n0 h4ck1ng
  • Start date Start date
N

n0 h4ck1ng

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