WOW this is the 2nd most amazing thing I have ever seen! First is the birth of my son of course. THANKS VERY MUCH!

FYI...I am using the first code provided...

A couple questions for you...1, how does this work? And 2, if I change the file name of "ADB" to something else, will I have to change it in the macro as well since it looks as if it is looking for the file name? Does it look for the account number, then item number, and then dump the case sales there?

I have different markets (different account numbers) as well that have their own sales data. Everything is in the same format though. This is just one market. I tried to read the code and make sense of it, but if you could tell me what the macro is calling for, or referencing, I will know how to adjust it for the other accounts if need be. Once I see what it is doing, I can grasp it. Again, THANKS FOR YOUR TIME. This is great.