I have figured out a possible solution and this is working for me even
though I am not sure this may be the best solution. The key is to drop a
numeric or text field on to the cell in the first column and change the
name. Every time a new row is copied the name stays the same and
therefore the Row1[" + i +"] can be used in a for
loop.http://forms.stefcameron.com/2009/02/25/expandable-table-with-totals/