I first want to thank everyone for the wonderful help you have been while learning to write macros. I have been researching my problem for the last 2 days but could come up with no answers. I will try to explain what I am trying to do first, then the problems I am facing, followed by my code. I want to apologize in advance if I did not get the correct terminology. I was self taught.

What I want to do:
Simply, I would like to add multiple arrays/Ranges together depending on a certain variable. Sheet(1) contains Unique Names. I would like to designate value of cell as defined variable. Then move to another sheet, start at the top of list and if the Sheet(1).Range("A2").Value = ActiveCell.Value then set variable as Range("Xi:Xj").Value. Next step (or loop) find next match and add to previous range. Range("Yi:Yj") = Range("Xi:Xj") + Range("Yi:Yj") At the end of the loop I would like to go back to Sheet(1) and paste results and move down to next Name

Problem:
I have a dynamic set of data that will change monthly. I would like to add sets of data together without having to go back and forth between worksheets (Speed). While running the macro, the defined range will always stay static.

My current Code:

Please Login or Register  to view this content.