Hi

Its not clear to me how you vb autofilter to give you a list from column A
and then go through the list to extract the relevant data from say column B.

Any pointers welcome

Alex