I am trying to figure out how to copy the audit results from 200+ workbooks in to a summary worksheet in another workbook. The audit results are based on the number correct and number that are incorrect. These results are always located on L98:L99 in each of the 200+ workbooks. The summary sheet is alphabetical based on each auditor and the groups they work on. I want the user to be able to enter the group name and the quarter from the audit results workbooks.
Based on the user input, I want the code to copy the audit results and then search the summary worksheet to find the correct group and the correct quarter and paste the audit results to the corresponding specific cells.
MS Off Ver: 2013
Thanks for you help!