How can I add columns without moving formulas. I need to have formulas stay
in column a,b,c, When I add column formula goes to b,c,d, it needs to stay
where is is.
Thanks for any help
Casey
How can I add columns without moving formulas. I need to have formulas stay
in column a,b,c, When I add column formula goes to b,c,d, it needs to stay
where is is.
Thanks for any help
Casey
Add a column after c?
the vallues in the columns have to move but not the formula
"Morrigan" wrote:
>
> Add a column after c?
>
>
> --
> Morrigan
> ------------------------------------------------------------------------
> Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
> View this thread: http://www.excelforum.com/showthread...hreadid=466290
>
>
use indirect() - see help.
=INDIRECT("B1")/INDIRECT("A1")
"Casey" wrote:
> the vallues in the columns have to move but not the formula
>
> "Morrigan" wrote:
>
> >
> > Add a column after c?
> >
> >
> > --
> > Morrigan
> > ------------------------------------------------------------------------
> > Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
> > View this thread: http://www.excelforum.com/showthread...hreadid=466290
> >
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks