Tim Hanson
Member
I have names in two columns ColA and ColB, and ColC is there orientation to one another
The 1st row says christine knows tim and there orientation is cw(Clockwise) the 2nd row says tim knows christine and there orientation is ccw(counter clock wise)
The 5th row says bill knows frank and there orientation is cw(Clockwise) the 8th row says frank knows bill and there orientation is ccw(counter clock wise)
I need a macro to start on row 1 write cw in ColC then look for the reverse paring (tim christine) then wite ccw in ColC ajacent to the pairing, then repeat this process for all name parings
I have 100,00 rows so it needs speed
I am going nowhere trying to code this I am at a loss!
Thank you
The 1st row says christine knows tim and there orientation is cw(Clockwise) the 2nd row says tim knows christine and there orientation is ccw(counter clock wise)
The 5th row says bill knows frank and there orientation is cw(Clockwise) the 8th row says frank knows bill and there orientation is ccw(counter clock wise)
I need a macro to start on row 1 write cw in ColC then look for the reverse paring (tim christine) then wite ccw in ColC ajacent to the pairing, then repeat this process for all name parings
I have 100,00 rows so it needs speed
I am going nowhere trying to code this I am at a loss!
Thank you
Code:
ColA ColB ColC
christine tim cw
tim christine ccw
christine chanda cw
joe betty cw
bill frank cw
bill viktor cw
hank mona
frank bill ccw
mona hillery cw
betty joe ccw
victor bill ccw
chanda christine ccw
hillery mona ccw