I have a range of cells lets say A1:B10. In Column B, there is an "x" every
so often. I need a macro that will look down Column B1:B10 and for every
time there is an "x" copy what is in the adjacent cell in Column A to Sheet1
cell A1 then A2 then A3 etc.

Please helpt.


--
Thanks
Shawn