How do i view only the filtered results from autofilter ?

[simon]

If a use an autofilter on a long list of data, it shows the filtered items at
the top of the page with blue line numbers, but it also shows the remaining
results underneath. Is there anyway of just showing the filtered results ?
thanks

 

[Marcelo]

Hi Simon,

I think you have a empty row between your data, if it's true, exclude the
row and try to filter again
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"simon" escreveu:

 

[simon]

thanks, that works a treat. Very Clever.........

Hi Simon,

I think you have a empty row between your data, if it's true, exclude the
row and try to filter again
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"simon" escreveu:

 

[Marcelo]

thanks for the feedback

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"simon" escreveu: