Hi Everyone,

I've been reading your Forum, for a few years now and it has been extremely helpful. Thank you! This is my first time posting a question, so I apologize if it's in the wrong section.

Background Info:
Employees are to receive two evaluations throughout the year, I currently have a shared Excel spreadsheet that has employee names predefined as rows and evaluation elements as columns. After each evaluation is completed, supervisors enter the employee's scores into the Excel spreadsheet, and also complete a PDF Fillable form which is printed and signed by both the employee and the supervisor. Therefore, supervisors are entering the information twice, once into Excel, and once into the PDF.

Question:
Is there a way to have a form populate after each complete entry in Excel? All the information I've found so far state that the data can be merged however, it ends up being like a mail merge, all at once. Since this document is added to throughout the year, I would only want to populate the latest entry each time. Should I use Access instead of Excel for this? I'm more knowledgeable in Excel and therefore more comfortable with it.

Any and all guidance is appreciated.

Nancy