software

I have the following formula in cell D7
(=sumif(MAR!$C:$C,C7,MAR!$O:$O)). Every month I have to update the
quot;MARquot; with the new month (i.e., next month it will be quot;APRquot;). quot;MARquot;,
quot;APRquot;, etc are the name of the other tabs that contain the data I need.
Is there a way to link that part (quot;MARquot;) of the formula to a cell (the
name of the tab), so when I change the value in the cell it
automatically updates my formula?

Any help is highly appreciated,

Thanks -----
J Garces--
JGarces
------------------------------------------------------------------------
JGarces's Profile: www.excelforum.com/member.php...oamp;userid=30406
View this thread: www.excelforum.com/showthread...hreadid=536406You can use indirect or edit/replace

--
Don Guillett
SalesAid Software

quot;JGarcesquot; gt; wrote in
message ...
gt;
gt; I have the following formula in cell D7
gt; (=sumif(MAR!$C:$C,C7,MAR!$O:$O)). Every month I have to update the
gt; quot;MARquot; with the new month (i.e., next month it will be quot;APRquot;). quot;MARquot;,
gt; quot;APRquot;, etc are the name of the other tabs that contain the data I need.
gt; Is there a way to link that part (quot;MARquot;) of the formula to a cell (the
gt; name of the tab), so when I change the value in the cell it
gt; automatically updates my formula?
gt;
gt; Any help is highly appreciated,
gt;
gt; Thanks -----
gt; J Garces
gt;
gt;
gt; --
gt; JGarces
gt; ------------------------------------------------------------------------
gt; JGarces's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30406
gt; View this thread: www.excelforum.com/showthread...hreadid=536406
gt;
Look in HELP for the INDIRECT() function

--
Kind regards,

Niek Otten

quot;JGarcesquot; gt; wrote in message
...
|
| I have the following formula in cell D7
| (=sumif(MAR!$C:$C,C7,MAR!$O:$O)). Every month I have to update the
| quot;MARquot; with the new month (i.e., next month it will be quot;APRquot;). quot;MARquot;,
| quot;APRquot;, etc are the name of the other tabs that contain the data I need.
| Is there a way to link that part (quot;MARquot;) of the formula to a cell (the
| name of the tab), so when I change the value in the cell it
| automatically updates my formula?
|
| Any help is highly appreciated,
|
| Thanks -----
| J Garces
|
|
| --
| JGarces
| ------------------------------------------------------------------------
| JGarces's Profile: www.excelforum.com/member.php...oamp;userid=30406
| View this thread: www.excelforum.com/showthread...hreadid=536406
|