exporting data from a userform using listboxes

I'm not sure if my title explains what I am trying to ask,

I am attempting to write code to copy data from nonadjacent cells of one worksheet to a worksheet in a different workbook. I have written the code to copy and paste all of the data except one section of data that comes from a userform listbox. Two codes for the listbox are

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The worksheet that is receiving the data is on the idea of a logbook. I have a column for each member and in each row I put a "1" in the cell if they were present and the cell is left blank if they were not. At the bottom of each column is a formula that calculates the percentage of calls present compared to the toltal number of calls.

In the worksheet that will be sending the data, the names that are checked in the listbox are dumped into a merged range of cells with semicolons between them. I need to be able to paste a "1" for each name that is selected.
If someone has an idea of how to do this, I would really apreciate the help.

Ok,

Lets see if I can try this again. The uploaded file should contain two different files, a report form file and a log book file, they are both dummy files but the only differences from the originals are that I replaced real life names with Name 1, Name 2 etc.

You will probably need to enable the macros to make the form work right, but maybe not. Rows 87-88 when selected, automatically pop-up a userform listbox with the names of all of the members. When a name is selected, and the userform closed, that name(s) is then put into the merged cells in rows 87-88.

In the other file, you will see a simple log book and at the end of the row, there is a column for each member. What I want to do is to have a "1" added to the column under each persons name that was selected in the userform. I have other data that is copy/pasted into the logbook from the report form and so all I need is to figure out how to get the member data to copy and paste and then I will call the copy/paste code when running the save code so that when you click the save button at the bottom of the report form, it will all happen at the same time.

I wondered if I need to somehow paste information from the userform into seperate cells in the report form (one for each member and hide them) and then run the same code that I use for the other data that is copy/pasted.

I would appreciate any help that I can get

Thanks in advance.

Yes RoyUK,

I will run the following code or something similar when saving to make sure that the logbook is also open.

Please Login or Register  to view this content.

Is it possible to do this or would I be better off populating a list in a different manner?

Does anyone know a good way to make the data get to the logbook?