A
AAS
two excel worksheets. Worksheet 1 includes all of the employees along with
their hourly rate. These employees can also be filtered according to their
job position. In worksheet 2 the company is broken down into different job
positions and the quantity of people in each job position..it also has their
average hourly wage. I want to link the two worksheets therefore if you add
an employee to worksheet 1, then worksheet 2's formula will also include the
newly added employee's hourly wage into the average on worksheet 2.
Thanks for any help you might have.
their hourly rate. These employees can also be filtered according to their
job position. In worksheet 2 the company is broken down into different job
positions and the quantity of people in each job position..it also has their
average hourly wage. I want to link the two worksheets therefore if you add
an employee to worksheet 1, then worksheet 2's formula will also include the
newly added employee's hourly wage into the average on worksheet 2.
Thanks for any help you might have.