Could someone help me with this? On my XL 2003 wb I have two of several
sheets. On one of the sheets (C"Monthly inv") it has my facilities
monthly inventory. On the other sheet (Monthly order req forms) it has
a series of columns that contain formulas specific to the current date
and the date that the data on (C"Monthly inv") was entered.
So what I am really trying to ask is there a way in xl for a formula in
(Monthly order req forms) to search and find a specific column {in
reference to the current date} in (C"Monthly inv") and change all the
equations in the (Monthly order req forms) W.S.?

Example, say the date is 6Feb06 a formula in W.S. (Monthly order req
forms) would search row c12:n13 in W.S. (C"Monthly inv") and find that
the date corresponds to column J. Thus all the equations in the W.S. or
column would change its letter variable to j.


--
Custermd