I need a command button that will, calculate the average, frequency and put the summarized on a new sheet.
In Sheet One I have Company Name(a), work area(b) quantity delivered(c), accidents(d) percentage(e) and frequency(f).
The work area is a unique number and a company name can have multiple work areas.
Every week I enter the quantity delivered, accidents and percentage for each work area.
When I press the command button I will need it to sum quantity delivered and accidents, calculate average of perecentage and divide quantity delivered by number of accidents for each company and have this summarized on sheet two. On sheet two I only want to see one line for each company. Can this be done?