So Close Yet So Far!!!!!

[n0 h4ck1ng]

hope this make sense and someone can HELP!


ok so ive gotten the information ineed to go from one sheet to th
other in the cells it needs to go and ive been given a simple code t
make cells that i select constant.

My problem is that it would take to long to go throught the sheet an
select all these cells that i need changed to constants.

heres the scenario: in col A i have dates for a 28 da
month(a2=8/15/05, a4=8/16/05, a6=8/17/05 etcic col Bi have a produc
name(beef), info in this col is collected fromfrom a cell on anouthe
sheet that changes daily and inputed under the correct date. Follow s
far? cols c and d do calcs based on those #'sthan it starts over in co
e(chicken) f an g, so on and so on. so for a spacfic day, lets sa
8/15/05 info would go from one sheet to this date sheet in cells a2
e2, h2,k2,and n2, each one being the qty of a different item, thi
hapens in about 100 cells throughout the sheet. Than tomarrow i coun
again and the #'s got to the correct date ie a3, e3, h3, k3.

what i need is a code that will select a2, e2 h2 k2 etc and make the
constant when i hit the button than the next day it will selec
a3,e3,h3,k3 anddo the same

thank you in advance

Leo

 

[Bryan Hessey]

Leon,

can you post the code for the lines (cells) that you already have, and
are you using a 'Day(Now())' cell to determine which row the data is
stored on?

Thanks