Userform data to multiple worksheets

**JessFace** · 07-23-2010, 05:04 PM

Hi all,

I have created a userform with textboxes, comboboxes and command buttons.

It basically serves as a meeting agenda database.

I have about 20 options under my "Meeting Attendee" combobox. The options consist of the first and last name initial of people whom my boss will be meeting with. I have so far created it so that all of the information from the userform goes into one worksheet. But I have realized that this is not the best option. I require for each entry to go to the respective sheet of the meeting attendee (i.e. if he chooses Allan as his meeting attendee the information should go to a worksheet named "Allan", if he chooses KT the info should go to a worksheet named "KT".

I am teaching myself vba and am not very familiar with it. Can anyone please help?

Thanks

**royUK** · 07-24-2010, 01:28 AM

All information is best kept on one sheet.

Attach an example workbook

**wali** · 07-24-2010, 04:47 AM

sorry!! i posted in wrong thread! And am deleting the text.
sorry

**foxguy** · 07-24-2010, 11:59 PM

Hi JessFace;

As Roy says, you're better off keeping all the data in 1 sheet, 1 row per meeting attendee. Then use filters to display the data you want to see. You will be happier down the road if you do. You will constantly be upgrading the workbook and you don't want to have several sheets that are identical in design and you have to modify them all. If you need to have a sheet to display the data for one meeting attendee and the userform isn't adequate then put a Listbox on it to select the meeting attendee and use formulas to "look at" the appropriate row on the data sheet.

**JessFace** · 07-28-2010, 10:18 AM

Here is the code that i am using, the only problem is that everything is going on the "Allan" sheet, i think that it is because of the second command in my code. My boss prefers to have everything separated out into different worksheets, hence the multiple worksheets.

I attached my spreadsheet.

**royUK** · 07-28-2010, 11:43 AM

Your code tells the form to write to that sheet.

Please Login or Register  to view this content.

You need to work through the rest of your code & edit it to remove the selecting & unnecessary looping as I have done here

**JessFace** · 08-04-2010, 11:53 AM

Roy,

Thanks a million times for your help!
Kudos to you.

I do have one other question/request though. I have been looking for a way to change my print code so that my boss can choose what spreadsheet he would like to print. Would you know i way to code that>

Thanks
Jess