A solution based on reference to a previous sheet seems cumbersome to me. I attach a file where I have shown another possibility in which, by the way, it will be very easy to make a pivot table.

Attached Files

30 Day Running Total_2.xls (262.5 KB, 24 views)

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