further to my recent post I'n now completely dazed and confused in
macroland. Believe me, I've tried but programming just isn't my thing.

This is complicated to explain so forgive a long post. I'm looking at
overlapping memberships of various groups and have at this stage a
worksheet with two columns of data  to hold the overlap data. Column A
holds the name of a group and adjacent to it in column B will be the
name of an individual member of the group. Column B is sorted on the
individual names of people.

I need to sequentially copy off the group names that an individual
might belong to and paste transpose it elsewhere for further processing.

I imagine that a method might be based on looking down column B until
a change of name occurs and then moving over to column A to read
off/copy the corresponding group names that a person belongs to. I've
tried to get somewhere with that approach and some others but just
can't get my head around it. AJ kindly posted something that looks
like it might have some bearing on this but really I don't know what's
going on.