Macro for collecting data for summation on separate spreadsheet

Hey all,

I'm new to VBA and I'm trying to figure out how to create a macro that will pull numbers out of a seperate spreadsheet based on the name given in that row and match it with the same name in the first spreadsheet while summing all of the rows with the same name. I would then like to do the same thing again, except separate the sum of the rows based on not only what name they have, but also whether they're green or red. It's kind of hard for me to explain so I've included a basic example of what I'd be starting with in this post. Any help is appreciated!

Attachment 101833

Is this thread different from this: http://www.vbforums.com/showthread.p...nd-Reformating

?

Yes it is. Tbh it's for the same project, but what I'm trying to do here is different from that post (otherwise I would've just used the responses I got in that post haha :bigyello:)