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: http://www.excelforum.com/member.php...o&userid=32536
View this thread: http://www.excelforum.com/showthread...hreadid=523211

But when they re-edit the worksheets all of the
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:

http://contextures.com/xlNames01.html#Dynamic

Biff

"kermitforney"
wrote in message
news:kermitforney.24ryna_1142533203.1037@excelforu m-nospam.com...

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:
http://www.excelforum.com/member.php...o&userid=32536
View this thread: http://www.excelforum.com/showthread...hreadid=523211

kermit

See Debra Dalgleish's site for info on setting up "dynamic" ranges that take
into account fluctuating sizes.

http://www.contextures.on.ca/xlNames01.html#Dynamic


Gord Dibben MS Excel MVP

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


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?