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

34407211756830
000 Staples IV
	RC 636 <=587
34407212013659
WI RC 636 w/N

<TBODY>
</TBODY>

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?