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
--
Gary's Student


"Sean" wrote:

> 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
>