Hi,
I have some data which looks like below:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Country[/TD]
[TD]Code[/TD]
[/TR]
[TR]
[TD]Germany[/TD]
[TD]Germany[/TD]
[TD]DE[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]Germany[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Nancy[/TD]
[TD]Germany[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fred[/TD]
[TD]Germany[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Brian[/TD]
[TD]Germany[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]France[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Danny[/TD]
[TD]France[/TD]
[TD]FR[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]France[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Nancy[/TD]
[TD]France[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fred[/TD]
[TD]France[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Derrick[/TD]
[TD]France[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I want to try and find a way of copying the code to the cells below it. My logic is:
Scroll down Column C (Code)
Copy first non-empty cell
Paste to next empty cell
Repeat
When get to non-empty cell copy that cell and carry out above process
Is there a way to fix this?
The data is about 30,000 rows long and my problem field is in Column H.
Any help much appreciated!
I have some data which looks like below:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Country[/TD]
[TD]Code[/TD]
[/TR]
[TR]
[TD]Germany[/TD]
[TD]Germany[/TD]
[TD]DE[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]Germany[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Nancy[/TD]
[TD]Germany[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fred[/TD]
[TD]Germany[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Brian[/TD]
[TD]Germany[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]France[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Danny[/TD]
[TD]France[/TD]
[TD]FR[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]France[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Nancy[/TD]
[TD]France[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fred[/TD]
[TD]France[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Derrick[/TD]
[TD]France[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I want to try and find a way of copying the code to the cells below it. My logic is:
Scroll down Column C (Code)
Copy first non-empty cell
Paste to next empty cell
Repeat
When get to non-empty cell copy that cell and carry out above process
Is there a way to fix this?
The data is about 30,000 rows long and my problem field is in Column H.
Any help much appreciated!