Copy row 5 active sheet then select where to copied row

Hi Folks,

I'm looking for a macro that will copy Row 5 of the Tab "Data Sheet" then ask me where I want it pasting?

I'm sure I had this before, but looking through my previous posts I don't seem to be able to find it.

Any help would be great.

Please Login or Register  to view this content.

Try this

No Problem. I know the big forum guru people would appreciate if you mark this as solved if it did provide the solution.

Just so you know. This is what I've done thus far:

Please Login or Register  to view this content.

Would love to know if there's a solution to enable me to mouse click on the row number rather than having to input the row number

Ta!

I thought I posted a reply so my apologies but the only way I know how that would work is to have the row selected before you run the Macro. So in general the process would be:
1) select target row
2)Run this Macro

Please Login or Register  to view this content.