| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel should carry cell protection to other office productivity pr | Excel Discussion (Misc queries) | |||
| Can Excel 2003 cell link carry with it the source cell format? | Excel Discussion (Misc queries) | |||
| Excel Formula Help! | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| excel formula calculation turned off?? | Excel Discussion (Misc queries) | |||
Threaded Mode
