Ok, I have tried to explain what I am trying to do with no success. I am going to post my excel document instead, I believe it will be be easier. If you open this workbook, on the manager input sheet, you will see a button that say something about running the macro. Click it and it will take you to the performance grid sheet and put all of the names on the grid where they are supposed to be.
Now:
As you will see there is a table at the bottome that is not filled out. What I want the macro to do is put all of the people in each colored zone, into the appropriate column in the table below the grid. PLEASE give me some hints here, I have tried multiple things, and they do not work. Of couse I could simply do a copy and paste of each cell, but that would look bad.
The end result will be a performance grid that is locked for editing, but with a distribution table below it that is editable.
Reply With Quote