Aloha Xor & No Sparks!

Thank you, both, for your rapid response! I was up against a deadline so I ended up using a helper sheet which isn't the most effective or logical way but it got the job done. Now that the system was approved I can incorporate a more effective way of getting the same result in order to optimize results in the future. I will definitely look deeper into both angles - Pivot Tables and Macros. Thank you again and have wonderful days!

HelicopterChick