hoping someone here can help, im decent with excell but just heard about macros... here is what i want to do and i feel like there should be an easy way to do it...any ideas would be appreciated:
initial sheet...
A B C D
L2 amy 2 1
P4 bill 4 4
D4 jill 1 2
L2 amy 3 3
N5 john 7 8
D4 jill 8 3
desired results...
A B C D
L2 amy 5 4
P4 bill 4 4
N5 john 7 8
D4 jill 9 5
initial sheet...
A B C D
L2 amy 2 1
P4 bill 4 4
D4 jill 1 2
L2 amy 3 3
N5 john 7 8
D4 jill 8 3
desired results...
A B C D
L2 amy 5 4
P4 bill 4 4
N5 john 7 8
D4 jill 9 5