G
Guest
I have 2 seperate sheets. I want to pull the accuracy rates (Acc%1 and Acc%2)
from sheet #2 to sheet #1- it needs to reference by month and year. How can I
do this? Help!
Sheet 1
A B C D E
F
Year Month TSR Name Acc % 1 Acc%2%
2 2006 7 SMG Smith, George
3 2006 7 STR Rayan, Steve
4 2006 7 HVJ Johnson, Howard
Sheet 2
A B C D
E F
Year Month1 EE# TSR Acc % 1 Acc % 2
1 2006 7 32958 Smith, George 17.9% 74.3%
2 2006 7 32558 Rayan, Steve 5.9% 98.1%
3 2006 7 13538 Johnson, Howard 88.0% 90.5%
Thanks!
from sheet #2 to sheet #1- it needs to reference by month and year. How can I
do this? Help!
Sheet 1
A B C D E
F
Year Month TSR Name Acc % 1 Acc%2%
2 2006 7 SMG Smith, George
3 2006 7 STR Rayan, Steve
4 2006 7 HVJ Johnson, Howard
Sheet 2
A B C D
E F
Year Month1 EE# TSR Acc % 1 Acc % 2
1 2006 7 32958 Smith, George 17.9% 74.3%
2 2006 7 32558 Rayan, Steve 5.9% 98.1%
3 2006 7 13538 Johnson, Howard 88.0% 90.5%
Thanks!