So Close Yet So Far!!!!!
 

hope this make sense and someone can HELP!


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

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

heres the scenario: in col A i have dates for a 28 day
month(a2=8/15/05, a4=8/16/05, a6=8/17/05 etcic col Bi have a product
name(beef), info in this col is collected fromfrom a cell on anouther
sheet that changes daily and inputed under the correct date. Follow so
far? cols c and d do calcs based on those #'sthan it starts over in col
e(chicken) f an g, so on and so on. so for a spacfic day, lets say
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, this
hapens in about 100 cells throughout the sheet. Than tomarrow i count
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 them
constant when i hit the button than the next day it will select
a3,e3,h3,k3 anddo the same

thank you in advance

Leon


--
n0 h4ck1ng
------------------------------------------------------------------------
n0 h4ck1ng's Profile: http://www.excelforum.com/member.php...o&userid=18410
View this thread: http://www.excelforum.com/showthread...hreadid=395873

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

n0 h4ck1ng Wrote:
hope this make sense and someone can HELP!


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

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

heres the scenario: in col A i have dates for a 28 day
month(a2=8/15/05, a4=8/16/05, a6=8/17/05 etcic col Bi have a product
name(beef), info in this col is collected fromfrom a cell on anouther
sheet that changes daily and inputed under the correct date. Follow so
far? cols c and d do calcs based on those #'sthan it starts over in col
e(chicken) f an g, so on and so on. so for a spacfic day, lets say
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, this
hapens in about 100 cells throughout the sheet. Than tomarrow i count
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 them
constant when i hit the button than the next day it will select
a3,e3,h3,k3 anddo the same

thank you in advance

Leon


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=395873