I'm working with a rather long list that I'm trying to add to the end of a spreadsheet. I know there are formula's out there that can go to the next empty cell in a row or a column, but I need a vba code that can go to the next empty cell in a row based on the first column's value.
For example:
Sample list:
[TABLE="width: 100"]
<tbody>[TR]
[TD]Dog[/TD]
[TD]Pitbull[/TD]
[/TR]
[TR]
[TD]Cat[/TD]
[TD]Sphynx[/TD]
[/TR]
[TR]
[TD]Dog[/TD]
[TD]Beagle[/TD]
[/TR]
[TR]
[TD]Bird[/TD]
[TD]Parrot[/TD]
[/TR]
</tbody>[/TABLE]
Sample spreadsheet:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Bird[/TD]
[TD]Toucan[/TD]
[TD]Owl[/TD]
[TD]Eagle[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dog[/TD]
[TD]Rottweiler[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cat[/TD]
[TD]Siamese[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Final result:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Bird[/TD]
[TD]Toucan[/TD]
[TD]Owl[/TD]
[TD]Eagle[/TD]
[TD]Parrot[/TD]
[/TR]
[TR]
[TD]Dog[/TD]
[TD]Rottweiler[/TD]
[TD]Pitbull[/TD]
[TD]Beagle[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cat[/TD]
[TD]Siamese[/TD]
[TD]Sphynx[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Is there any easy way to do this?
For example:
Sample list:
[TABLE="width: 100"]
<tbody>[TR]
[TD]Dog[/TD]
[TD]Pitbull[/TD]
[/TR]
[TR]
[TD]Cat[/TD]
[TD]Sphynx[/TD]
[/TR]
[TR]
[TD]Dog[/TD]
[TD]Beagle[/TD]
[/TR]
[TR]
[TD]Bird[/TD]
[TD]Parrot[/TD]
[/TR]
</tbody>[/TABLE]
Sample spreadsheet:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Bird[/TD]
[TD]Toucan[/TD]
[TD]Owl[/TD]
[TD]Eagle[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dog[/TD]
[TD]Rottweiler[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cat[/TD]
[TD]Siamese[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Final result:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Bird[/TD]
[TD]Toucan[/TD]
[TD]Owl[/TD]
[TD]Eagle[/TD]
[TD]Parrot[/TD]
[/TR]
[TR]
[TD]Dog[/TD]
[TD]Rottweiler[/TD]
[TD]Pitbull[/TD]
[TD]Beagle[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cat[/TD]
[TD]Siamese[/TD]
[TD]Sphynx[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Is there any easy way to do this?