R
Ryk
Hope I can get a bit of help on this, we have about 2000 rows and 50 or
so cells in our row that have formulas that have "(INDIRECT(T$1&
"$AB6") in them, as an example. The problem is we'd like to
filldown but the "$AB6" part of it will not change to "$AB7",
"$AB8" as it is pulled down. We need to keep the " " because
it has to reference a cell. Is there a way to do this? I'll example
what we have and what we'd like the next few to become....
=IF(OR(INDIRECT(T$1& "$AB6")="Car parts"),400,0)
=IF(OR(INDIRECT(T$1& "$AB7")="Car parts"),400,0)
=IF(OR(INDIRECT(T$1& "$AB8")="Car parts"),400,0)
=IF(OR(INDIRECT(T$1& "$AB9")="Car parts"),400,0)
Thank you for any help given.
Dave
so cells in our row that have formulas that have "(INDIRECT(T$1&
"$AB6") in them, as an example. The problem is we'd like to
filldown but the "$AB6" part of it will not change to "$AB7",
"$AB8" as it is pulled down. We need to keep the " " because
it has to reference a cell. Is there a way to do this? I'll example
what we have and what we'd like the next few to become....
=IF(OR(INDIRECT(T$1& "$AB6")="Car parts"),400,0)
=IF(OR(INDIRECT(T$1& "$AB7")="Car parts"),400,0)
=IF(OR(INDIRECT(T$1& "$AB8")="Car parts"),400,0)
=IF(OR(INDIRECT(T$1& "$AB9")="Car parts"),400,0)
Thank you for any help given.
Dave