software

I am creating a spread sheet and need to know if I can have the formulas
change if needed?

This is basically a short template 100-150 rows but it flucuates
depending on the user. But when they re-edit the worksheets all of the
formulas need to be rewritten for the new length.

Is there anyway I can bind the formulas or somehow have them resize
automatically based on certain criteria?--
kermitforney
------------------------------------------------------------------------
kermitforney's Profile: www.excelforum.com/member.php...oamp;userid=32536
View this thread: www.excelforum.com/showthread...hreadid=523211gt;But when they re-edit the worksheets all of the
gt;formulas need to be rewritten for the new length.

Do you mean the formulas need to be adjusted for the range size?

Use dynamic ranges:

contextures.com/xlNames01.html#Dynamic

Biff

quot;kermitforneyquot; gt;
wrote in message
news:kermitforney.24ryna_1142533203.1037@excelforu m-nospam.com...
gt;
gt; I am creating a spread sheet and need to know if I can have the formulas
gt; change if needed?
gt;
gt; This is basically a short template 100-150 rows but it flucuates
gt; depending on the user. But when they re-edit the worksheets all of the
gt; formulas need to be rewritten for the new length.
gt;
gt; Is there anyway I can bind the formulas or somehow have them resize
gt; automatically based on certain criteria?
gt;
gt;
gt; --
gt; kermitforney
gt; ------------------------------------------------------------------------
gt; kermitforney's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32536
gt; View this thread: www.excelforum.com/showthread...hreadid=523211
gt;
kermit

See Debra Dalgleish's site for info on setting up quot;dynamicquot; ranges that take
into account fluctuating sizes.

www.contextures.on.ca/xlNames01.html#DynamicGord Dibben MS Excel MVP

On Thu, 16 Mar 2006 12:16:07 -0600, kermitforney
gt; wrote:

gt;
gt;I am creating a spread sheet and need to know if I can have the formulas
gt;change if needed?
gt;
gt;This is basically a short template 100-150 rows but it flucuates
gt;depending on the user. But when they re-edit the worksheets all of the
gt;formulas need to be rewritten for the new length.
gt;
gt;Is there anyway I can bind the formulas or somehow have them resize
gt;automatically based on certain criteria?