Hello,
I have data in Column A to B. Column A="Unit Number" , Column B = "Delivery Name" and Column C = "Postcode". The Issue I have, the titles of each of the columns are in the data set.[TABLE="width: 500"]
<tbody>[TR]
[TD]Unit Number[/TD]
[TD]Delivery Name[/TD]
[TD]Postcode[/TD]
[/TR]
[TR]
[TD]2234we[/TD]
[TD]Home[/TD]
[TD]JK34 4FG[/TD]
[/TR]
[TR]
[TD][TABLE="width: 451"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col><col></colgroup>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Unit Number[/TD]
[TD]Delivery Name[/TD]
[TD]Postcode[/TD]
[/TR]
[TR]
[TD]243243fg[/TD]
[TD]Away[/TD]
[TD]RG34 4GF[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
What I need the VBA, Macro or Formula to do so is copy the data down until it has reached the titles mentioned above.
Thank you for your help
[TABLE="width: 93"]
<tbody>[TR]
[TD][TABLE="width: 66"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[TABLE="width: 93"]
<tbody>[TR]
[TD][TABLE="width: 292"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[TABLE="width: 66"]
<tbody>[TR]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
I have data in Column A to B. Column A="Unit Number" , Column B = "Delivery Name" and Column C = "Postcode". The Issue I have, the titles of each of the columns are in the data set.[TABLE="width: 500"]
<tbody>[TR]
[TD]Unit Number[/TD]
[TD]Delivery Name[/TD]
[TD]Postcode[/TD]
[/TR]
[TR]
[TD]2234we[/TD]
[TD]Home[/TD]
[TD]JK34 4FG[/TD]
[/TR]
[TR]
[TD][TABLE="width: 451"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col><col></colgroup>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Unit Number[/TD]
[TD]Delivery Name[/TD]
[TD]Postcode[/TD]
[/TR]
[TR]
[TD]243243fg[/TD]
[TD]Away[/TD]
[TD]RG34 4GF[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
What I need the VBA, Macro or Formula to do so is copy the data down until it has reached the titles mentioned above.
Thank you for your help
[TABLE="width: 93"]
<tbody>[TR]
[TD][TABLE="width: 66"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[TABLE="width: 93"]
<tbody>[TR]
[TD][TABLE="width: 292"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[TABLE="width: 66"]
<tbody>[TR]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]