How to filter only the numbers I need

[Guest]

I have a list of phone numbers, some of the numbers have multiple numbers
associated with them, some do not. When I autofilter, I see all the numbers
I need, but I cannot copy the autofilter list, nor can I select an option to
list all the numbers that I see when I open the autofilter. I just need what
I see when I autofilter, how can I copy the autofilter list.

 

[Peo Sjoblom]

What does that mean, do you get an error message when you copy them or what?
Normally you just select the range in a filtered list and copy it then paste
it somewhere else,
you can also try by selecting the visible list, press F5, click special and
select visible cell only press enter and then copy.



--


Regards,


Peo Sjoblom

 

[PCLIVE]

Are you saying that you use the auto filter to get the numbers you want, and
then you try to copy those numbers and paste them to another worksheet?
And are you saying that instead of only copying the visible filtered
numbers, it is also copying the non visible numbers?
It seems to work for me. When I past, it only pastes the numbers that were
visible. Which Excel version are you using?

Regards,
Paul

 

[Gord Dibben]

With list filtered, F5>Special>Visble cells only>OK

Now copy the highlighted range.


Gord Dibben MS Excel MVP