I have a sample sheet from a larger file that I have to sort monthly.
The raw data is the basis for billing the customer. This sheet feeds a summary sheet which is then sent to the customer for payment.
I need to sort the sheet by Agent, Interval and Type. Agent is the specific product that they are using; interval is the portion of an hour that they it updated. Type is the number of web pages they are seeing on their browser.
I also want to have the SubTotal and number of day columns underneath each agent type as well.
I was trying to create macro but soon realized that it was beyond my grasp at this time.