Creating POs (purchase orders) for vendors from raw sales data.

We have raw data that contains sales information including sales agent ID, time of sale, and what they sold, Each sale needs to be converted into an hourly value for each sale. This needs to be completed weekly. We need to have the macro spit out a PO for each sales representative based on the hourly value of each sale. I’ve included a “raw data” file example.