How do I pull only certain data from one section to another section?
In my spreadsheet for example, I have something like this here:
[TABLE="class: grid, width: 777"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]ORG[/TD]
[TD]FIRST[/TD]
[TD]LAST[/TD]
[TD]DATE[/TD]
[TD][/TD]
[TD]FIRST[/TD]
[TD]LAST[/TD]
[TD]DATE[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2[/TD]
[TD]Matthew[/TD]
[TD]Johnson[/TD]
[TD]5/2/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]Mark[/TD]
[TD]Anderson[/TD]
[TD]2/7/2014[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[TD]Luke[/TD]
[TD]Jones[/TD]
[TD]8/7/2014[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD]Esau[/TD]
[TD]Smith[/TD]
[TD]1/1/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD]Cain[/TD]
[TD]Williams[/TD]
[TD]3/17/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]2[/TD]
[TD]John[/TD]
[TD]Miller[/TD]
[TD]3/16/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Of the rows in Column A denoted with the number 2, I need its corresponding data in Columns B, C and D to appear automatically or by VBA in Columns F, G and H. So that it would look like this here:
[TABLE="class: grid, width: 777"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]ORG[/TD]
[TD]FIRST[/TD]
[TD]LAST[/TD]
[TD]DATE[/TD]
[TD][/TD]
[TD]FIRST[/TD]
[TD]LAST[/TD]
[TD]DATE[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2[/TD]
[TD]Matthew[/TD]
[TD]Johnson[/TD]
[TD]5/2/2015[/TD]
[TD][/TD]
[TD]Matthew<strike></strike>[/TD]
[TD]Johnson<strike></strike>[/TD]
[TD]5/2/2015<strike></strike>[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]Mark[/TD]
[TD]Anderson[/TD]
[TD]2/7/2014[/TD]
[TD][/TD]
[TD]Mark<strike></strike>[/TD]
[TD]Anderson<strike></strike>[/TD]
[TD]2/7/2014<strike></strike>[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[TD]Luke[/TD]
[TD]Jones[/TD]
[TD]8/7/2014[/TD]
[TD][/TD]
[TD]Luke<strike></strike>[/TD]
[TD]Jones<strike></strike>[/TD]
[TD]8/7/2014<strike></strike>[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD]Esau[/TD]
[TD]Smith[/TD]
[TD]1/1/2015[/TD]
[TD][/TD]
[TD]John<strike></strike>[/TD]
[TD]Miller[/TD]
[TD]3/16/2017<strike></strike>[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD]Cain[/TD]
[TD]Williams[/TD]
[TD]3/17/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]2[/TD]
[TD]John[/TD]
[TD]Miller[/TD]
[TD]3/16/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
What are some ways I could accomplish this?
In my spreadsheet for example, I have something like this here:
[TABLE="class: grid, width: 777"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]ORG[/TD]
[TD]FIRST[/TD]
[TD]LAST[/TD]
[TD]DATE[/TD]
[TD][/TD]
[TD]FIRST[/TD]
[TD]LAST[/TD]
[TD]DATE[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2[/TD]
[TD]Matthew[/TD]
[TD]Johnson[/TD]
[TD]5/2/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]Mark[/TD]
[TD]Anderson[/TD]
[TD]2/7/2014[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[TD]Luke[/TD]
[TD]Jones[/TD]
[TD]8/7/2014[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD]Esau[/TD]
[TD]Smith[/TD]
[TD]1/1/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD]Cain[/TD]
[TD]Williams[/TD]
[TD]3/17/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]2[/TD]
[TD]John[/TD]
[TD]Miller[/TD]
[TD]3/16/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Of the rows in Column A denoted with the number 2, I need its corresponding data in Columns B, C and D to appear automatically or by VBA in Columns F, G and H. So that it would look like this here:
[TABLE="class: grid, width: 777"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]ORG[/TD]
[TD]FIRST[/TD]
[TD]LAST[/TD]
[TD]DATE[/TD]
[TD][/TD]
[TD]FIRST[/TD]
[TD]LAST[/TD]
[TD]DATE[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2[/TD]
[TD]Matthew[/TD]
[TD]Johnson[/TD]
[TD]5/2/2015[/TD]
[TD][/TD]
[TD]Matthew<strike></strike>[/TD]
[TD]Johnson<strike></strike>[/TD]
[TD]5/2/2015<strike></strike>[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]Mark[/TD]
[TD]Anderson[/TD]
[TD]2/7/2014[/TD]
[TD][/TD]
[TD]Mark<strike></strike>[/TD]
[TD]Anderson<strike></strike>[/TD]
[TD]2/7/2014<strike></strike>[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[TD]Luke[/TD]
[TD]Jones[/TD]
[TD]8/7/2014[/TD]
[TD][/TD]
[TD]Luke<strike></strike>[/TD]
[TD]Jones<strike></strike>[/TD]
[TD]8/7/2014<strike></strike>[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD]Esau[/TD]
[TD]Smith[/TD]
[TD]1/1/2015[/TD]
[TD][/TD]
[TD]John<strike></strike>[/TD]
[TD]Miller[/TD]
[TD]3/16/2017<strike></strike>[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD]Cain[/TD]
[TD]Williams[/TD]
[TD]3/17/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]2[/TD]
[TD]John[/TD]
[TD]Miller[/TD]
[TD]3/16/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
What are some ways I could accomplish this?
Last edited: