Userform, Search, copy an paste data from a userform database to another sheet.

Good Evening All,

I appreciate any help or direction that the community here can offer.

I have included and excel sheet (with comments) of what i have accomplished to date; vba is completely new to me, so I have been doing as much reading as my job allows.

To start, here is the situation: I have to log test results from students into excel, then manipulate and analyze the data in a couple of months. Each student will be assessed around 6 times, depending on failures, on various tests in various roles with various instructors. I created a user form so the teachers could enter the data themselves as they assess.

Every time the userform is used, it will add an entry into Candidate Data Log.

What I need to do now, is take all the test results for each student and summarize into a single row by student. I put an example in the summarize sheet done manually.

So for example, Tom has done two tests, Toms row on the summarize sheet would show the first test results, in in Row 14 from B14-J14 and his second test from K14 to S14, and so on as tests are done. Each student has a row unique row.

The reason for populating the data like this is so that I can use mail-merge each to populate the Data into weekly assessment forms showing all the tests they accomplished that week with the test data.

I put in the comments on excel how I thought I could do it, but the coding is beyond me.

Essentially I think I need a macro to search down column A in the log, take the first name, copy the adjacent 9 cells, then search for the same name in the summarize sheet, check for an empty column beside it, if true past the result, then continue to search, on the next entry it would do the same thing except to a different student. When it finds a name, and check for an empty cell it would paste the date in the row, after the previous data, in the next empty cell. After it reaches the end of the log it would stop.

This may be entirely round-about way of doing this, if so let me know, the end result is to have a log of individual chits as well as chits listed horizontally by student.

Again thank for any help, and I apologize for the large explanation, I just wanted to be as clear as possible.

Regards,

Mason

Thank you for your response,

I appologize for taking so long to get back. I did not include any actual data from the students for policy reasons. Each student will be indentified by a student number and their last name (Candidate Name) and (StNumber). Would you like me to fill in the lists with example data to work from?

Thanks again,

Mason

Mehmetcik,

Here it is. I included an additional sheet that has a wish list item on it, it might not be possible in excel or it might be a bad idea, treat it as such if so.

Again I really appreciate your help.

Thanks,

Mason