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