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

P

pmms

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!
 
R

Reesey

pmms said:
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!
Click to expand...

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.
 
F

Fred Smith

Go to Tools>Options>Edit, and check 'Extend list formats and formulas'. See if
that does what you want.
 
P

pmms

Thanks, I'll give that a try.

Reesey said:
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.
Click to expand...
 
Top