![]()  | 
	
| 
		 
			 
			#1  
			 
			
			
			
			
		 
		
	 | 
|||
		
		
  | 
|||
| 
		
	
		
		
			
			 
			
			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  | 
| 
		 
			 
			#2  
			 
			
			
			
			
		 
		
	 | 
||||
		
		
  | 
||||
| 
		
	
		
		
			
			 
			
			See 'Add a row to a table in a protected form' at: http://www.gmayor.com/word_vba_examples.htm 
		
		
		
		
For the summing problem, perhaps the simplest solution is to split the table (which will also make it easier to add the new rows), bookmark it, then use a formula field coded like: {=SUM(MyTable C:C)} where 'MyTable' is the bookmark name and 'C' is the column you want to sum. 
				__________________ 
		
		
		
		
		
	
	Cheers, Paul Edstein [Fmr MS MVP - Word]  | 
| 
		 
			 
			#3  
			 
			
			
			
			
		 
		
	 | 
|||
		
		
  | 
|||
| 
		
	
		
		
			
			 
			
			Thank you, sir!  I've been searching Word/Window forums for nearly a week, I don't know how I managed to not find that thread before.  Also, thanks for the split table/code field advice, it is truly appreciated.  I've actually read dozens of your replies to other users, when I saw your name in the response e-mail I read this morning, I was pleased knowing I would receive a helpful reply instead of another "I don't know how to answer your question so I would do something else...." answer that I've been getting elsewhere. 
		
		
		
		
		
		
		
		
	
	Thanks again!  | 
 
 | 
	
	
| Tags | 
| conditional, insert row, tables | 
| 
		 | 
			 
			Similar Threads
		 | 
	||||
| Thread | Thread Starter | Forum | Replies | Last Post | 
		
		  Odd behaviour of table - keep rows together
	 | 
	Stephan Lindner | Word Tables | 1 | 09-10-2011 05:31 AM | 
		
		  adding rows to word table
	 | 
	hklein | Word VBA | 4 | 07-18-2011 12:21 AM | 
		
		  Fixing number or rows in a table
	 | 
	burnsie | Word | 2 | 07-12-2011 02:59 AM | 
| Repeating table rows in template? | TheWedgie | Word | 0 | 09-11-2010 09:35 PM | 
| Help Autoformating a Table w 2 header rows | Julie713 | Word Tables | 0 | 03-01-2010 08:15 AM |