copy data in first empty cell

[Justair07]

Hello,

I can't seem to get the following code to do what I'd like. It's very close but it's missing one thing. I would like for the macro to paste the selected data in the first empty cell in coulmn F. It seems to want to past directly across from the data it's coping in column F, not the first empty cell.

Please Login or Register  to view this content.

Thank you,

[AB33]

Please Login or Register  to view this content.

[Justair07]

Perfect!! AB33 you are awesome. I see what I was doing wrong in my own attempts.

Thanks again.

[AB33]

Justair,
I wrote the first code, so knew where the bolts were.
You are welcome!