I have two different workbooks, a test book and a results book. I would like
to have a command button, that when clicked, opens the results workbook and
fill the users name and answers in the appropriate columns, say A1 through
G1. Then it saves the results workbook, closes it, and clears the contents of
the cells in the test workbook that contains the answers the user selected.
Then when someone else takes the test and does the same thing, their answers
are saved BELOW the first person in the results workbook, allowing me to use
the same test workbook and log everyone's results n the same workbook. I know
how to call open a new workbook, save and close it, and clear the contents,
but what I don't know is how to get the second or third or fourth users
answers to be entered in the row below the person before them. Hope this
makes sense and someone can help. Thanks!