I have a Workbook that has a Input Tab with two columns of data in two separate 15 cell rows. Each set represents a set of answers that a specific person is responsible for. What I'm looking to do is each time a name is entered, the rows are cleared and when data is entered, it's "logged" to another worksheet. When the name changes to another person, it again clears the data and new data is entered. On the log sheet, the new data is then recorded in adjacent cells so as to show the new data from the new person. The goal is to collect data from multiple persons without having to copy and paste. I have attached a sample workbook.
Much thanks in advance,