[TABLE="width: 500"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]=sheet2 A2
[/TD]
[TD]=sheet2 B2
[/TD]
[TD]=sheet2 C2
[/TD]
[TD]=sheet2 D2
[/TD]
[/TR]
[TR]
[TD]text
[/TD]
[TD]text
[/TD]
[TD]text
[/TD]
[TD]text
[/TD]
[/TR]
[TR]
[TD]text[/TD]
[TD]text
[/TD]
[TD]text
[/TD]
[TD]text
[/TD]
[/TR]
[TR]
[TD]=sheet2 A3[/TD]
[TD]=sheet2 B3
[/TD]
[TD]=sheet2 C3
[/TD]
[TD]=sheet2 D3
[/TD]
[/TR]
[TR]
[TD]text
[/TD]
[TD]text
[/TD]
[TD]text
[/TD]
[TD]text
[/TD]
[/TR]
[TR]
[TD]text
[/TD]
[TD]text
[/TD]
[TD]text
[/TD]
[TD]text
[/TD]
[/TR]
[TR]
[TD]=sheet2 A4
[/TD]
[TD]=sheet2 B4
[/TD]
[TD]=sheet2 C4
[/TD]
[TD]=sheet2 D4
[/TD]
[/TR]
[TR]
[TD]text
[/TD]
[TD]text
[/TD]
[TD]text
[/TD]
[TD]text
[/TD]
[/TR]
[TR]
[TD]text
[/TD]
[TD]text
[/TD]
[TD]text
[/TD]
[TD]text
[/TD]
[/TR]
</tbody>[/TABLE]
Hi guys,
I hope you could extend a little help. I've got two sheets in my workbook and what I want to do is to automate the "sheet1" upon encoding the data in "sheet2". However "sheet 1" is somehow formatted as above:
I intend to encode the data in another worksheet, "sheet2":
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]123A
[/TD]
[TD]John
[/TD]
[TD]01022018
[/TD]
[TD]250
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]123B
[/TD]
[TD]Joseph
[/TD]
[TD]01032018
[/TD]
[TD]300
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]123C
[/TD]
[TD]Aaron
[/TD]
[TD]01042018
[/TD]
[TD]400
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]123D
[/TD]
[TD]Michael
[/TD]
[TD]01052018
[/TD]
[TD]150
[/TD]
[/TR]
</tbody>[/TABLE]
Thank you in advance.
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]=sheet2 A2
[/TD]
[TD]=sheet2 B2
[/TD]
[TD]=sheet2 C2
[/TD]
[TD]=sheet2 D2
[/TD]
[/TR]
[TR]
[TD]text
[/TD]
[TD]text
[/TD]
[TD]text
[/TD]
[TD]text
[/TD]
[/TR]
[TR]
[TD]text[/TD]
[TD]text
[/TD]
[TD]text
[/TD]
[TD]text
[/TD]
[/TR]
[TR]
[TD]=sheet2 A3[/TD]
[TD]=sheet2 B3
[/TD]
[TD]=sheet2 C3
[/TD]
[TD]=sheet2 D3
[/TD]
[/TR]
[TR]
[TD]text
[/TD]
[TD]text
[/TD]
[TD]text
[/TD]
[TD]text
[/TD]
[/TR]
[TR]
[TD]text
[/TD]
[TD]text
[/TD]
[TD]text
[/TD]
[TD]text
[/TD]
[/TR]
[TR]
[TD]=sheet2 A4
[/TD]
[TD]=sheet2 B4
[/TD]
[TD]=sheet2 C4
[/TD]
[TD]=sheet2 D4
[/TD]
[/TR]
[TR]
[TD]text
[/TD]
[TD]text
[/TD]
[TD]text
[/TD]
[TD]text
[/TD]
[/TR]
[TR]
[TD]text
[/TD]
[TD]text
[/TD]
[TD]text
[/TD]
[TD]text
[/TD]
[/TR]
</tbody>[/TABLE]
Hi guys,
I hope you could extend a little help. I've got two sheets in my workbook and what I want to do is to automate the "sheet1" upon encoding the data in "sheet2". However "sheet 1" is somehow formatted as above:
I intend to encode the data in another worksheet, "sheet2":
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]123A
[/TD]
[TD]John
[/TD]
[TD]01022018
[/TD]
[TD]250
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]123B
[/TD]
[TD]Joseph
[/TD]
[TD]01032018
[/TD]
[TD]300
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]123C
[/TD]
[TD]Aaron
[/TD]
[TD]01042018
[/TD]
[TD]400
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]123D
[/TD]
[TD]Michael
[/TD]
[TD]01052018
[/TD]
[TD]150
[/TD]
[/TR]
</tbody>[/TABLE]
Thank you in advance.