Creating Macro for Individual Tab/Chart Creation

Hello:

I am a real beginner when it comes to Excel macros and VB, but I think I have a situation where creating one would be really helpful. I have attached the Excel file I am working with for reference.

I have an excel chart which has productivity metrics on employees (Columns A - I) in a group, and the mean, 75th%ile and 90%iles (Row 12-14) across the entire group. There are then a series of formulas (Columns L - S) which calculate the total bonus payment to each person, based on their productivity.

Below this calculation, I have a table (shaded with blue fill in Rows 18 and 20-25)) that show the 3 "tiers" of performance each person can achieve.

What I would like to do is create an "individual report card" that creates either a separate tab or separate page in a report for each employee that shows their metrics and how their bonus was calculated, with the "tiers" of performance at the bottom.

I would welcome anyone's help with this and thank you in advance from this quasi-newbie.

Thanks,
E

Hi

How about updating your example file to include a second sheet that contains the format and details of what you would like to see in the individual performance report card. Pick an employee, and show the details so we can see what to work towards.


rylo

Originally Posted by rylo

Hi

How about updating your example file to include a second sheet that contains the format and details of what you would like to see in the individual performance report card. Pick an employee, and show the details so we can see what to work towards.


rylo

Great idea - sorry, I'm a bit new at this. I'm re-attaching the file with a second tab "Individual Report Card" to show how I would want the data to appear. Many thanks in advance for your help!

Hi

Try this.

There is a drop down in A3 that allows you to select the rep. Rest flows from there.

rylo

Thanks for putting that together! I think I may not have explained what I am trying to do very well.

I would like to create that sample report card for every employee by clicking on a button or starting up a macro that creates a tab for each employee and generates that sample report card for all.

Is this something you know how to do and could help with?

Thanks again for all of your help so far-

Ebachenh

Hi

OK, try this. Run the macro and the individual sheets will be created in this file.

rylo

Perfect! Thanks so much for your help!