Copy selected data to a user defined destination

[kaesuma]

Hi,

I need to know how to write a VB code that will:

copy selected data
prompt for user to input the destination cell
paste data into destination cell (could be in another w/sheet)

Hats off to VB gurus.

Thanking in advance -Uma

[Simon Lloyd]

Try this, but it needs to be triggered, you could have a button run the code.

Please Login or Register  to view this content.

[kaesuma]

Thank you. It works great. !!!
Thanks a million.

I can carry out my task much more effeciently now.

Uma