R
Rush
First of all , Hello everyone .
My question is this ..Regarding a fantasy Football program i have.
I use Vlookup to gather information about a player (from a named range
"players"
in a1 i input his code (through to k1)
cells b1,c1,d1,e1,f1 give me his Position,Name,Team,Value and current
score
This happens 11 times to form the 11 players
We have 2 transfers a year where we swap 3 players and i use the same
vlookup in cells m1,n1,o1 to register players out
and in q1,r1,s1, 3 players in ..I hope this makes some sense
what i want to do is put the 3 players transferred in into the cells
of the 3 players transferring out in the original team of 11 ???
Any help greatly appreciated or a much easier way to do it ?
My question is this ..Regarding a fantasy Football program i have.
I use Vlookup to gather information about a player (from a named range
"players"
in a1 i input his code (through to k1)
cells b1,c1,d1,e1,f1 give me his Position,Name,Team,Value and current
score
This happens 11 times to form the 11 players
We have 2 transfers a year where we swap 3 players and i use the same
vlookup in cells m1,n1,o1 to register players out
and in q1,r1,s1, 3 players in ..I hope this makes some sense
what i want to do is put the 3 players transferred in into the cells
of the 3 players transferring out in the original team of 11 ???
Any help greatly appreciated or a much easier way to do it ?