How do I insert a line in excel and carry the formula forward?
 

I'm creating a form that will be used for data entry and one cell is the
product of 2 other cells. If the user needs to insert more lines the formula
does not carry forward. Any suggestions? Thanks!

How do I insert a line in excel and carry the formula forward?
 

pmms Wrote:
I'm creating a form that will be used for data entry and one cell is
the
product of 2 other cells. If the user needs to insert more lines the
formula
does not carry forward. Any suggestions? Thanks!

I would create a macro (using the macro recorder - that's easiest) that
copies and inserts a line with the formulas in it. Then I would add the
macro to the toolbar and tell end user that they need to insert new
lines via the toolbar command (or you create an 'icon'). This is one
idea - maybe someone out there has a more sophisticated solution.


--
Reesey
------------------------------------------------------------------------
Reesey's Profile: http://www.excelforum.com/member.php...o&userid=36764
View this thread: http://www.excelforum.com/showthread...hreadid=564882

How do I insert a line in excel and carry the formula forward?
 

Go to ToolsOptionsEdit, and check 'Extend list formats and formulas'. See if
that does what you want.

--
Regards,
Fred


"pmms" wrote in message
...
I'm creating a form that will be used for data entry and one cell is the
product of 2 other cells. If the user needs to insert more lines the formula
does not carry forward. Any suggestions? Thanks!

How do I insert a line in excel and carry the formula forward?
 

Thanks for your reply. I already have that 'turned on' and it doesn't do it.

"Fred Smith" wrote:

Go to ToolsOptionsEdit, and check 'Extend list formats and formulas'. See if
that does what you want.

--
Regards,
Fred


"pmms" wrote in message
...
I'm creating a form that will be used for data entry and one cell is the
product of 2 other cells. If the user needs to insert more lines the formula
does not carry forward. Any suggestions? Thanks!

How do I insert a line in excel and carry the formula forward?
 

Thanks, I'll give that a try.

"Reesey" wrote:


pmms Wrote:
I'm creating a form that will be used for data entry and one cell is
the
product of 2 other cells. If the user needs to insert more lines the
formula
does not carry forward. Any suggestions? Thanks!

I would create a macro (using the macro recorder - that's easiest) that
copies and inserts a line with the formulas in it. Then I would add the
macro to the toolbar and tell end user that they need to insert new
lines via the toolbar command (or you create an 'icon'). This is one
idea - maybe someone out there has a more sophisticated solution.


--
Reesey
------------------------------------------------------------------------
Reesey's Profile: http://www.excelforum.com/member.php...o&userid=36764
View this thread: http://www.excelforum.com/showthread...hreadid=564882