Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can Excel do this? (Template?)
I am creating a spread sheet and need to know if I can have the formula change if needed? This is basically a short template 100-150 rows but it flucuate depending on the user. But when they re-edit the worksheets all of th formulas need to be rewritten for the new length. Is there anyway I can bind the formulas or somehow have them resiz automatically based on certain criteria -- kermitforne ----------------------------------------------------------------------- kermitforney's Profile: http://www.excelforum.com/member.php...fo&userid=3253 View this thread: http://www.excelforum.com/showthread.php?threadid=52320 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can Excel do this? (Template?)
Possibly use defined names/ranges instead of absolute references
Insert=name=Define name: Loc1 Refersto: =offset(Sheet1!$a$1,0,0,Counta(sheet1!$A:$A),1) then in your cell formula =Sum(Loc1) or you can do it directly =sum(offset(Sheet1!$a$1,0,0,Counta(sheet1!$A:$A),1 )) If it was as simple as sum, you could just do =sum(A:A) and not have to worry about changing it. However, this assumes you want to sum anything in the column. Anyway, hopefully this will give you some ideas. -- Regards, Tom Ogilvy "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? -- kermitforney ------------------------------------------------------------------------ kermitforney's Profile: http://www.excelforum.com/member.php...o&userid=32536 View this thread: http://www.excelforum.com/showthread...hreadid=523208 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Template (Creating a Function in the template) | Excel Worksheet Functions | |||
How can I link between a Word template and an Excel template | Excel Discussion (Misc queries) | |||
NCAA tournament brackets template from Template gallery. | Excel Worksheet Functions | |||
I want to create a template like invoice template in excel. | Excel Programming | |||
Excel template to load automatically as the default template? | Excel Discussion (Misc queries) |