Creating a log sheet macro to copy a generated text string to the next line on a log page

Greetings all!

My wife tasked me with creating a spreadsheet for us to work with our online students. We have new students starting all of the time, so they can be anywhere in the course at any moment. She wants one page for the oral quiz for each chapter, with an assortment of questions to choose from. Since we also need to discuss how they are doing in the class, she would like each page to also have a place for that information. I can concatenate all of the junk that would be output into something looking like this (Html line breaks included on purpose):

Student, Joe<br>Module 1 DBA<br>09/02/13<br>t1 (10/10)<br>t3 (10/10)<br>t6 (10/10)<br>t8 (10/10)<br>t10 (10/10)<br><br>50/50<br><br>Mr. Reifsneider<br><Br>09/02/13<br>Monthly call with:<br>Student<br>mom<br><br>Current course metrics:<br>Grade: 90, % complete: 45, Weeks Active: 6, Last Assignment: 08/30/13, assignments remaining: 18 <br>Comments: <br>

That was prepared using this formula:

Formula:

Please Login or Register  to view this content.

along with another formula for the contact part (G18).

The one thing that I am smashing my head against the wall on is how to take that output stuff from the quiz page, and save it on the log sheet page, with a new row for each quiz completed. I had done something similar from a userform which worked great, but that makes it so that we cannot jump between spreadsheets. Here is how I did it from the userform (the me.Output.value was for the same kind of stuff put into a text box called Output):

Please Login or Register  to view this content.

When I tried to put the stuff from my cell into a variable (M1Out), and then pass that to my log sheet, it does not seem to do anything at all.

Please Login or Register  to view this content.

If anyone has any ideas, I would greatly appreciate them. In the interim, we can copy and paste them from the page as is into our other systems. It would just be nice to have an independent set of records.

Spreadsheet attached.

ReifyNewDBASheetStart.xlsm

Hi,

So basically you want the information thats on the sheet "Module 1 DBA" go to sheet "LogSheet " when ou press a button. Correct?

Now if that's the case you are going to need a "Student ID" or a unique cualifier so that person does not get duplicates. Because there is the possivility that that person might have to be updated correct?

Thanks

No key needed, they just need to add to the next line down. We can look them up with ctrl-F, and will not go back and edit them. I will eventually have a button to press. Once it is all set, I will duplicate the entire page so there is a separate sheet in the workbook for each chapter. I do not know if I would need to write a separate macro for each, or if it could be done with activeworksheet

OK, this looks like a step in the right direction.

Please Login or Register  to view this content.

It seems to at least paste it in the right spot if I do some of the leg work on my own.