Command button copy selection to another sheet

I am relatively new to using Macros and cannot figure out how to code a command button to do the following:

I have two sheets:

Sheet1 has the following cells that need the following data entered:
A1 to enter Name
A2 to enter Job Title
A3 to enter Department

Sheet 2 is a list of choices:
Names in Column A
Jobs Title in Column B
Departments in Column C

I have a command button on sheet 2 that should do the following:
when I select any name on sheet2 and click the command button, it will copy that name, cooresponding Job title, and Department for that person into the appropriate cells on sheet 1 (A1, A2, and A3)

This is a little too complicated for me to figure out on my own and any help is very much appreciated!!

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

I have edited your Thread tile this time.

Take a look at the Contacts form example here

http://excel-it.com/vba_examples.htm

Hello hlester,

Welcome to the Forum!

Here is the code to add to your button.

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time.
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.

Add the Macro to the Command Button
1. Right Click the Button.
2. Click View Code...
3. A new window will open in the Visual Basic Editor like below

Please Login or Register  to view this content.

4. Type in the macro's name. You code you should like this...

Please Login or Register  to view this content.

5. Press Ctrl+S to save the changes.
6. Press Alt+Q to return to Excel.

You are using a forms Commandbutton not an ActiveX from the Controls Toolbox.

Do you have a Sheet1?

Hello hlester,

If you upload your workbook in Excel 2003 format, I can take a look at it and correct the problem for you.