How do i view only the filtered results from autofilter ?

S

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
 
M

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:
 
S

simon

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

Marcelo said:
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:
Click to expand...
 
M

Marcelo

thanks for the feedback

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



"simon" escreveu:
 
Top