Hi All,
I am coming to you with a question regarding filling in large amounts of data. I have a script which generates a column of data based on a couple fields my end users fill in. The next step I would like to automate is filling in other fields of each row for each value generated by the first script. The very first row is filled in by the end users based on controlled vocabulary/data validation. I need to copy the values down each column until i reach the last value of the 1st column. Here is what I mean graphically:
Here is what the table looks like after the first script:
[TABLE="class: grid, width: 192, align: center"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]ID Code[/TD]
[TD="width: 64"]Letter[/TD]
[TD="width: 64"]Number[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A5[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A6[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A7[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A8[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A9[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A10[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A11[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A12[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
And here is what I need to happen:
[TABLE="class: grid, width: 192, align: center"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]ID Code[/TD]
[TD="width: 64"]Letter[/TD]
[TD="width: 64"]Number[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A5[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A6[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A7[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A8[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A9[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A10[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A11[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A12[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
In reality, there are many more columns than just "letter" and "number" but im hoping to just adjust the code. I tried to figure out how to do this on my own, but my VBA skills are still pretty weak.
Thanks in advance!
I am coming to you with a question regarding filling in large amounts of data. I have a script which generates a column of data based on a couple fields my end users fill in. The next step I would like to automate is filling in other fields of each row for each value generated by the first script. The very first row is filled in by the end users based on controlled vocabulary/data validation. I need to copy the values down each column until i reach the last value of the 1st column. Here is what I mean graphically:
Here is what the table looks like after the first script:
[TABLE="class: grid, width: 192, align: center"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]ID Code[/TD]
[TD="width: 64"]Letter[/TD]
[TD="width: 64"]Number[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A5[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A6[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A7[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A8[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A9[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A10[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A11[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A12[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
And here is what I need to happen:
[TABLE="class: grid, width: 192, align: center"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]ID Code[/TD]
[TD="width: 64"]Letter[/TD]
[TD="width: 64"]Number[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A5[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A6[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A7[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A8[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A9[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A10[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A11[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]A12[/TD]
[TD]a[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
In reality, there are many more columns than just "letter" and "number" but im hoping to just adjust the code. I tried to figure out how to do this on my own, but my VBA skills are still pretty weak.
Thanks in advance!