Rusty Excel Skills looking to build a 'summary' page to pull 'name' and 'score/total' from each tab.

[treym]

Been away from Excel for a number of years. I building some training rubric grading sheets. Each person will have 2 different rubrics x 90 people = 180 total rubric. I'd like a summary page where it will grab the 'name' and total score from each tab, so I don't have to reference them myself. Is this a macro thing or am i overthinking it? Additionally, I will need to split each person's 2 rubrics to their own file for forwarding to them. How would that be done? Thanks!

 

[MARK858]

Thanks, I cannot get the plug in to work as it seems like the macro is being blocked somehow even though it is 'active' with full macros enabled.

Either put the Addin in a Trusted location

Add, remove, or change a trusted location in Microsoft Office - Microsoft Support

A trusted location is a folder that contains files you're confident are safe. See how to add, remove, or change a trusted location in Microsoft Office.

support.microsoft.com

or unblock the file as per

which is in the link in the XL2BB instructions note

XL2BB Instructions

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com