COPY DATA CELL TO CELL

[Sean]

I have a problem, I need a macro to do for me, I hope. I tried posting this
question once already, but I do not see it in the discussion list so we'll
try again.

I export data out from one program in to another, this is what it looks like.

Before I copy and paste...

A B
Row1 S201 854-12
Row2 999-99
Row3 600-00
Row4 700-00
Row5 S205 1234-5
Row6 333-22
Row7 888-22

-----------------------------------------------------------------------------------------
This is what it looks like after I finish with the copy and paste.

A B
Row1 S201 854-12
Row2 S201 999-99
Row3 S201 600-00
Row4 S201 700-00
Row5 S205 1234-5
Row6 S205 333-22
Row7 S205 888-22

Is there a Macro that can do this for me?

Thanks

 

[Gary''s Student]

A macro is not needed. Pick an un-used column, say C. In C1 enter:
=A1 in C2 enter:
=IF(A2="",C1,A2) and copy down
Copy column C and paste/special as value back into column A