User form with multiple row lines

  • 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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!