Userform macro that will upload information to multiple worksheets

[ExcelHacks_99]

Hey so I'm learning VBA right now and have realized how efficient it is, but i have a question regarding a project I'm working on. I currently have created a userform that uploads information placed in the textboxs in the next open cell . For instance, If excel hacks is in a textbox when i press submit it will send it to the next open column in the sheet.What I want to do is have the user form be able to read a name and depending on what name it reads send it to a specific sheet and also still document it in the overall summary sheet. IF that makes sense. Does anyone know how to do this?

[arlu1201]

Sure. Do you have a sample file that you can upload?

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 Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
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 button and wait until the file has uploaded.
10. Close the window and then click Submit.

[ExcelHacks_99]

Because of the project it is I can't actually upload the file here, but i can show an example of the code i'm using so far. As of now im using something like this:

Please Login or Register  to view this content.

As of now this code basically uploads all information into sheet2 in the next open cell. What i want for it to do is still upload the information in sheet two but depending on the name go into a specific sheet as well. For instance sheet3 is amy's list and sheet4 is henry's list. If amy puts her name and then her information and clicks submit I want all the info to be posted in sheet2 and then also in sheet3. and if henry puts his info in I want it to go into his sheet and the overall sheet.

[arlu1201]

You do not need to upload the original file you are working on. Even a sample file containing dummy data having the same format as your original file will do.