Hi! I am looking for help with formulas in my macro enabled form, which will allow the user to add multiple rows to enter free text under 3 headings (if they require more than 1 entry). I want to have an "Add Another" button which the user can click to copy more rows into the form automatically and so they can enter the details into. In relation to the below, If they click the button in row 23 to add another cause and control, rows 24 and 25 will duplicate (these can be added below row 23 each time for this heading). I need them to be able to add as many as they want for each heading (23, 26 and 29).
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Column A[/TD]
[TD]Column B[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]Causes and Controls (heading)[/TD]
[TD]"Add another" button[/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD]Cause[/TD]
[TD]Free text[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]Control[/TD]
[TD]Free text[/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]Consequences and Controls (heading)[/TD]
[TD]"Add another" button[/TD]
[/TR]
[TR]
[TD]27[/TD]
[TD]Consequence[/TD]
[TD]Free text[/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD]Control[/TD]
[TD]Free text[/TD]
[/TR]
[TR]
[TD]29[/TD]
[TD]Action Plans (heading)[/TD]
[TD]"Add another" button[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]Title[/TD]
[TD]Free text[/TD]
[/TR]
[TR]
[TD]31[/TD]
[TD]Details[/TD]
[TD]Free text[/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD]Owner[/TD]
[TD]Free text[/TD]
[/TR]
</tbody>[/TABLE]
I hope this makes sense- any advice is appreciated!
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Column A[/TD]
[TD]Column B[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]Causes and Controls (heading)[/TD]
[TD]"Add another" button[/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD]Cause[/TD]
[TD]Free text[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]Control[/TD]
[TD]Free text[/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]Consequences and Controls (heading)[/TD]
[TD]"Add another" button[/TD]
[/TR]
[TR]
[TD]27[/TD]
[TD]Consequence[/TD]
[TD]Free text[/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD]Control[/TD]
[TD]Free text[/TD]
[/TR]
[TR]
[TD]29[/TD]
[TD]Action Plans (heading)[/TD]
[TD]"Add another" button[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]Title[/TD]
[TD]Free text[/TD]
[/TR]
[TR]
[TD]31[/TD]
[TD]Details[/TD]
[TD]Free text[/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD]Owner[/TD]
[TD]Free text[/TD]
[/TR]
</tbody>[/TABLE]
I hope this makes sense- any advice is appreciated!