charchar001
New Member
- Joined
- Jun 24, 2019
- Messages
- 9
Hey guys,
I am still going through other threads to get more information to potentially combine something rudimentary.
till then,
I am trying to take data from a sheet from workbook and fill in another workbook that has a master "form" template and create new sheets filled in with each data set.
I.e. of the data sheet, the column order may change with user so i would need a versatile usage? Maybe a if statement to verify that the headers match the order. Column 1 would be what drives a new sheet
<tbody>
</tbody>
From that data it needs to go into the form template, in which the data will need to go to a specific cell/area.
After it has filled the fields required in the first sheet (row 1 data), it creates another sheet using row 2 data.
I am still going through other threads to get more information to potentially combine something rudimentary.
till then,
I am trying to take data from a sheet from workbook and fill in another workbook that has a master "form" template and create new sheets filled in with each data set.
I.e. of the data sheet, the column order may change with user so i would need a versatile usage? Maybe a if statement to verify that the headers match the order. Column 1 would be what drives a new sheet
Column 1 | Column 2 | Column 3 |
Op 1 | turtle | 2 |
op 2 | screw | 23 |
op 3 | cup | 3994 |
<tbody>
</tbody>
From that data it needs to go into the form template, in which the data will need to go to a specific cell/area.
After it has filled the fields required in the first sheet (row 1 data), it creates another sheet using row 2 data.