Hungry Horace
New Member
- Joined
- Dec 21, 2016
- Messages
- 10
I am new to Excel and learning as I go and hoping someone here can help me with what I believe is a VBA issue.
I am working on a workbook that's purpose is to create a final report for Participants in a course.
Basically on one sheet would be a list of participants, another sheet would be the attendance record for the participants, on another would be the results of the tests/exams the participants took, and so on.
I have a template that takes the data of each individual from the different sheets and creates a final 'Certificate' for each participant that shows their attendance, exam scores, course pass/fail etc.
Whilst I can link the sheets for certain parts of the data for the Certificate I am having trouble making all of it work.
Is someone able to help with this issue? I am happy to post / send the workbook and provide a detailed explanation of exactly what data should appear in each cell of the Certificate sheet.
Thank you in advance for the help .
I am working on a workbook that's purpose is to create a final report for Participants in a course.
Basically on one sheet would be a list of participants, another sheet would be the attendance record for the participants, on another would be the results of the tests/exams the participants took, and so on.
I have a template that takes the data of each individual from the different sheets and creates a final 'Certificate' for each participant that shows their attendance, exam scores, course pass/fail etc.
Whilst I can link the sheets for certain parts of the data for the Certificate I am having trouble making all of it work.
Is someone able to help with this issue? I am happy to post / send the workbook and provide a detailed explanation of exactly what data should appear in each cell of the Certificate sheet.
Thank you in advance for the help .