Hi,
I am trying to develop a user-form that I can add and update to multiple row lines. On sheet 1, I have the following information; the user would enter the date and enter the patient details,
[TABLE="class: cms_table, width: 299"]
[tr]
[td]
Date
[/td]
[TD="align: right"]13/07/2017[/TD]
[td]
[/td]
[td]
[/td]
[/tr]
[tr]
[td]
[/td]
[td]
[/td]
[td]
[/td]
[td]
[/td]
[/tr]
[tr]
[td]
Patient 1
[/td]
[td]
Outcome 1
[/td]
[td]
Outcome 2
[/td]
[td]
Reason 1
[/td]
[/tr]
[tr]
[td]
Patient 2
[/td]
[td]
Outcome 1
[/td]
[td]
Outcome 2
[/td]
[td]
Reason 1
[/td]
[/tr]
[tr]
[td]
Patient 3
[/td]
[td]
Outcome 1
[/td]
[td]
Outcome 2
[/td]
[td]
Reason 1
[/td]
[/tr]
[tr]
[td]
Patient 4
[/td]
[td]
Outcome 1
[/td]
[td]
Outcome 2
[/td]
[td]
Reason 1
[/td]
[/tr]
[tr]
[td]
Patient 5
[/td]
[td]
Outcome 1
[/td]
[td]
Outcome 2
[/td]
[td]
Reason 1
[/td]
[/tr]
[/TABLE]
I would then like this to be entered onto sheet 2 on multiple lines;
[TABLE="class: cms_table, width: 394"]
[tr]
[td]
[/td]
[td]
[/td]
[td]
[/td]
[td]
[/td]
[td]
[/td]
[/tr]
[tr]
[td]
13/07/2017
[/td]
[td]
Patient1
[/td]
[td]
Outcome1
[/td]
[td]
Outcome2
[/td]
[td]
Reason1
[/td]
[/tr]
[tr]
[td]
13/07/2017
[/td]
[td]
Patient2
[/td]
[td]
Outcome1
[/td]
[td]
Outcome2
[/td]
[td]
Reason1
[/td]
[/tr]
[tr]
[td]
13/07/2017
[/td]
[td]
Patient3
[/td]
[td]
Outcome1
[/td]
[td]
Outcome2
[/td]
[td]
Reason1
[/td]
[/tr]
[tr]
[td]
13/07/2017
[/td]
[td]
Patient4
[/td]
[td]
Outcome1
[/td]
[td]
Outcome2
[/td]
[td]
Reason1
[/td]
[/tr]
[tr]
[td]
13/07/2017
[/td]
[td]
Patient5
[/td]
[td]
Outcome1
[/td]
[td]
Outcome2
[/td]
[td]
Reason1
[/td]
[/tr]
[/TABLE]
Any help on this would be much appreciated.
Thanks