I have included the file with some data. The password that pops up when the file opens is "word". There is no password needed to view the Visual Basic code.

Now here is my problem:
When I pull the reports it is dropping data, but it doesn't seem to have any kind of patern to explain why.
On Dept01 it pulls all the paper charges for each record; however it does not pull any of the copy totals for those records.
On Dept03 and Dept06 it pulls all the paper charges for each record; however, it does not pull any of the network totals for those records.
On Dept07 it pulls all the paper charges and the xerox charge; however, it does not pull the copy charge.
On Dept12 it pulls all of the paper charges for all the records that have data. It pulls all the Local and Network charges for 3 of the records that have data, but it doesn't pull the copy data for these records. Yet there is one record that it pulls the paper charge but not the Network or copy charges.

I originally had more data and at times it will pick up copy charges so it does pick them up every now and then. I resorted the data on the User_Data sheet thinking that if I resorted the data I would get different results when I pulled the report, but this doesn't happen. It drops the same data on each record no matter where the record is located in the listing.

This is super wierd and to be honest I have no idea where to even begin to find a solution for this. I would appreciate any help I can get for this.