Copy and Paste Cell Based on Conditions

[drmingle]

I am not really sure the best way to go about this:

I have data in columns A and B.
If the data is in column A it will not be in column B.

My objective is to move the data in column A to column B, as long as it is not a number with the color yellow in the cell.

The data displays as follows:
**SPECIAL NOTE: Cells with 34407211756830 and 34407212013659 have yellow cells.
Column A Column B
[TABLE="class: grid, width: 100, align: left"]
<TBODY>[TR]
[TD]34407211756830[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]000 Staples IV[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]RC 636 <=587[/TD]
[/TR]
[TR]
[TD]34407212013659[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WI RC 636 w/N[/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]











I thought it would be possible to copy over everything in column A to B, exluding by cell color and if the cell was empty OR,
I thought it would be possilbe to copy over everything with cells that made use of a " " (space) for example "000 Staples IV" actually has 2 spaces present.

Of course, I would need the routine to cycle through each column until it hit the end of the data in column A.

Thanks in advance for your help.

 

[drmingle]

Curious to know if one should use the function find(" ") to locate cells with space and if that was true to simply cut.paste to column B in corrosponding cell?