Hi,
I have an excel spreadsheet with 60 employees rows 41-101. Name is in Column A. I have 8 sheets where senior management (sheets 1 - 8) ranked each for potential and performance 1-10 in column B and C. I want to create a new sheet for each employeee name that scatter plots all 8 sheet rankings where B = X and C = Y from sheets 1- 8.
I am very bad at scripting.
Thank you,
Ken
I have an excel spreadsheet with 60 employees rows 41-101. Name is in Column A. I have 8 sheets where senior management (sheets 1 - 8) ranked each for potential and performance 1-10 in column B and C. I want to create a new sheet for each employeee name that scatter plots all 8 sheet rankings where B = X and C = Y from sheets 1- 8.
I am very bad at scripting.
Thank you,
Ken