View Single Post
 
Old 05-17-2012, 07:34 AM
PMR PMR is offline Windows XP Office 2003
Novice
 
Join Date: May 2012
Posts: 2
PMR is on a distinguished road
Default Allow user to add rows to Word '03 table....how?

I have a form which includes an 8 column table, each cell in the row has a Text Form Field with various lengths/output formats. My problems are two fold:

1) I need to allow users to insert additional rows if needed, the new row needs to contain the same empty Text Form Fields and I cant for life of me figure out how to do this.

2) I need to auto sum one of the columns by adding the bookmarks for each cell above in that column....if users add additional rows I'm lost.....

I've created a similar form for a similar purpose but that form has a fixed number of rows. I was unable to use {=SUM(ABOVE)} as some cells may remain blank. Adding default values to the cells was unacceptable for end users, so I went with blanks and writing an excessively long formula to add 15 bookmarks. Bulky and complicated, but it works...

I suppose users would need to make some condition "True" (entering "Y" in a Text Field, clicking a button, something) and then have the new row appear, 1 row per one click.

Any suggestions are greatly appreciated.

PMR
Reply With Quote