Copy Highlighted Cell And Paste

Hello. I am trying to create a code that will copy the selected cell information and paste it where I want it.

Basically it is for a learner database I use at work, when I select John Smith (for example) I want it to copy his name and paste it into a fork lift booking form that I can print off.

Thank you in advance.

Hi samdegg

mehmetcik is correct

The microsoft commands ctrl c and ctrl V

will do that for you
I'd guess there's something your not telling/showing us.

What is it you have and what is it you wish it to be?

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" worksheet that demonstrates what you wish the output to be.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the "Add Files"... button to locate your file for uploading.
6. This will open a new window File Upload...Click "Select Files"
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the "Upload Files" button and wait until the file has uploaded.
10. Click the "Done" Button.

Hi Sam

Try this

Option Explicit

Sub Copy_Paste()
    ActiveCell.Copy Destination:=Range("G10")
End Sub

Hi Sam

You're missing a Dot (.)

ActiveCell.Copy Destination:=Sheets("FLT Assessment Form")Range("C9")

should be

ActiveCell.Copy Destination:=Sheets("FLT Assessment Form").Range("C9")

Hi Sam

Don't know what to tell you without seeing what you have...

Sure

Sheets("FLT Assessment Form").Activate

You're welcome...glad I could help...thanks for the Rep.

If this resolves your issue please mark your Thread as SOLVED.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save