I am new at this macro stuff and I would like to learn more. A project I'm doing now is for staff assessment forms. I already have a working macro for creating new assessment form for each new staff (from a "Template" sheet). So now I can create assessments for ABC, DEF, etc. etc.
One thing that I need is the "Summary" tab. Is it possible that the summary table in this tab will pick up the final assessment scores from each tab? Or with a click of a button, columns with contents from each assessment tab (ex: row R of each assessment tab is the average score from all assessors that needs to go to the summary tab) will be added to the end of the summary table?
So your final scores are all on the same location across your sheets. Then go to your summary sheet, select destination cell, hit =, go to first assessment sheet, click on the final score and hit enter. Do this for the rest of the scores.