salviakshay
New Member
Hi,
I am trying to make a Quality form in Excel, the questions will be one below the other with a drop down to choose from ( Yes, No, N/A) or Points (10, 15,20,30 etc).
I want a macro that helps me transpose all the results of one evaluation to a new sheet in horizontal format and add the date and time when the details were pasted. then clear the selections done in quality form so that the QA can make a second entry and then repeat the process again.
In short the macro should copy the scoring and final score to a new sheet, clear the form, let user enter new data and copy the details again to new sheet below the first one that was pasted
I am trying to make a Quality form in Excel, the questions will be one below the other with a drop down to choose from ( Yes, No, N/A) or Points (10, 15,20,30 etc).
I want a macro that helps me transpose all the results of one evaluation to a new sheet in horizontal format and add the date and time when the details were pasted. then clear the selections done in quality form so that the QA can make a second entry and then repeat the process again.
In short the macro should copy the scoring and final score to a new sheet, clear the form, let user enter new data and copy the details again to new sheet below the first one that was pasted
