Macro - Help please - Newbie on macros [Closed]

Report
Posts
1
Registration date
Friday May 2, 2014
Status
Member
Last seen
May 2, 2014
-
Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
-
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?

Assistance would be greatly appreciated!

Thanks in advance.

3 replies

Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
448
Hi Jneeley001,

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.

Best regards,
Trowa
Do you have time to help me out? I can send you my file. I just can't make it work. I think I got it, but when I run it, it's not functioning as intended.
Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
448
Hi Ryan,

My suggestion was without the use of macro, thus no need of running anything.

But you can always post your workbook (careful with personal info) using a free file sharing site like www.speedyshare.com or ge.tt and then post back the download link.

If I can help you, I will.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!