Hi all,

Still not getting excel macros as well as I hoped by now..

Have a LONG column (25000 values) that could contain any of eight values... I would like to search the column, find two matching values first instance and next instance and fill the spaces with those values.

Can this be done easily? I cannot...

Thanking you again...

JJ

Apple Apple
Apple
Apple
Apple Apple
Pear Pear
Pear
Pear
Pear
Pear Pear
Cherry Cherry
Cherry
Cherry Cherry