I hope this is clear enough...
Rows AB27 through AC39 in the Employee_data sheet has each month listed and can have anything in there, because this is info entered by the managers during the monthly review section that the managers will perform each month... I want to show it in ReviewAgents sheet section V25 through V37.
The code currently written features data already being pulled from the Employee_data sheet ... I was trying to use the same code again to pull the data from the employee_data sheet for the comments section Rows AC28 through AC39. I started the code by making the name of the rep load up in cell O24 by entering
=INDEX(EmployeeData!A2:A421,R4)
which shows the name of the rep - I then created a comments section at Rows AB27 through AC39 and am using the code
=INDEX(EmployeeData!AB27:AC39)
so it shows up in the ReviewAgents sheet starting at location V25
Sample2.xlsm
Hope this makes sense!
Respectfully,
John