Each month I download a CSV with the same headings. I then correct data with a VB program I have. This corrected data needs to be added to the master sheet on an ongoing basis so I need easy way to do that.
I need to have a progressive commission calculated to each sale amount and a few other calcs for each sale.
I then need a pivot table or similar created so I can analize this data as per sales analysis sheet attached.
I need to be able to analize data in as many ways possible from the info attached.
Please submit your excel experience or your bid may not be considered.