Hello all. I hope you can help me. I am currently writing some VBA
code to merge multiple spreadsheets together from various sources and
convert them into a single fixed format. What I want to do is filter
the contents of a spreadsheet using a distinct set of values from a
specific column.

The Autofilter function does this and the drop down contains a list of
unique values but I need to extract those unique values and use them
inconjuction with a loop to filter and process those rows. I have been
looking through various sites and books but I have not found a solution
to the problem.

I would be grateful for any help.


--
Golgo 13
------------------------------------------------------------------------
Golgo 13's Profile: http://www.excelforum.com/member.php...o&userid=26448
View this thread: http://www.excelforum.com/showthread...hreadid=397191