find and match

[tbobo]

I have the data:

x1 hello hi bye x4 x199 x83 x23
x4 hello hi bye
x8 hello hi bye
x199 hello hi bye
x3 hello hi bye
x10000 hello hi bye
x83 hello hi bye
x1001 hello hi bye
x999 hello hi bye
x23 hello hi bye
and
on
and
on

I need a macro that will give me the following results:

x1 hello hi bye finish x1 x199 x83 x23
x4 hello hi bye
x8 hello hi bye
x199 hello hi bye finish
x3 hello hi bye
x10000 hello hi bye
x83 hello hi bye finish
x1001 hello hi bye
x999 hello hi bye
x23 hello hi bye finish
and
on
and
on

[royUK]

I think you need to explain more fully.

[tbobo]

colum1 colum2 colum3 colum4 colum5 colum6 colum7 colum8 colum9 colum10 and on
x1 hello hi bye finish x1 x199 x83 x23
x4 hello hi bye
x8 hello hi bye
x199 hello hi bye finish
x3 hello hi bye
x10000 hello hi bye
x83 hello hi bye finish
x1001 hello hi bye
x999 hello hi bye
x23 hello hi bye finish
and
on
and
I need a macro that will read data in colum6 row1 (in this example will be colum6-colum7-colum8-colum9 with the data x1, x199, x83, x23 respectively data could go from colum6 to colum56). The Macro will then match the data in colum6, col7, col8...to the data in colum1 ...if there is a match, it will write the word "finish" in colum5 for every match.

colum1 colum2 colum3 colum4 colum5 colum6 colum7 colum8 colum9 colum10 and on
x1 hello hi bye finish x1 x199 x83 x23
x4 hello hi bye
x8 hello hi bye
x199 hello hi bye finish
x3 hello hi bye
x10000 hello hi bye
x83 hello hi bye finish
x1001 hello hi bye
x999 hello hi bye
x23 hello hi bye finish
and
on
and
on