Or just copy paste all the visible cells in that range. (and drop #2 and #3).

olasa wrote:

Simple
1. Use the Advanced filter on the Fax column Only Copy to another
location, to get a New list
2. Cut and Paste the Fax column so that it comes first in your Original
list
3. Then use VLOOKUP to transfere Name and Tel from the Original list to
the New list.
Done

Hope it helped
Ola Sandström

--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=390267

--

Dave Peterson