1.Have to compare contents of 2 cells.

2. IS cell1 same as cell2 ?

3. If yes: then copy 2 cells of cell2 into cell1.

4. If no: then compare cell1 to the next cell in line after cell2.

4b. Now IS cell1 same as cell2b?

5. If yes: then copy 2 cells of cell2b into cell1.

6. Next cell1

7. IS new cell1 the same as cell2?

8. Repeat until cell1 = 'end of filled column' OR cell2= 'end of
filled column' OR (loop total count of cell1 column).
note: =IF(cell1=end&&cell2=end) THEN good routine ELSE 'error
routine'.


Example:

Two excel columns in two different worksheets:

a1-worksheet1 a1-worksheet2
alan paul
randy alex
rica sarah
todd sigmund

I want to compare all of the name in the first 'worksheet column' to
the names in the second 'worksheet column'.

Where we find a matching set of name (not necessarily in the same
locations; row# x column#) we want to match the contents of 2 cells in
either worksheet to the contents of the other.

before
alan 23 14_oak_lane alan

after
alan 23 14_oak_lane alan 23 14_oak_lane