Find Common names in multi ranges

[JG]

I have 4 columns of names. I would like to search all 4 columns (4
individual ranges) and find the names that appear in all 4 and copy the
names to individual cells.

Thanks for any help and Merry Christmas (Happy Holidays..... pc)

 

[Don Guillett]

You could use a findnext within a for i loop something like this. Look at
FINDNEXT in vba help.

for i=1 to 4
columns(i).find
next i

 

[JG]

Sorry I didn't make myself clear enough. The 4 Columns of names are
with other data in the columns and they are spread out on the sheet. I
could not search a column but a range in a column ( 4 ranges actually),
don't know if this will make a difference.

Thanks JG

 

[Guest]

You have responses at your other post. Please don't multi-post.

 

[JG]

I was getting just VB solutions and wanted to see if there was a
conventional way around my problem, I through myself on the mercy of
the court!!

Merry Christmas to you!

 

[Don Guillett]

Not enough info. No mind reading here.