Thread
:
Autofilter doesn't work
View Single Post
#
5
Posted to microsoft.public.excel.misc
Dave Peterson
Posts: n/a
Autofilter doesn't work
If you select your range first, the autofilter should work against that
selection--even if there are empty rows/columns.
Sandy Mann wrote:
tombogman,
You need a continuous stream of data connected to the rows. Insert a new
column - say column A. Expand all you groups and then in A1 place any entry
and copy it down the full length of your data then hide column A again.
The Autofilter should then work.
--
HTH
Sandy
with @tiscali.co.uk
"tombogman" wrote
in message ...
Sandy Mann Wrote:
Autofilter stops at the first blank row.
any solution to this? another way to sort my data, maybe without
autofilter?
thx,
T.
--
tombogman
------------------------------------------------------------------------
tombogman's Profile:
http://www.excelforum.com/member.php...o&userid=30578
View this thread:
http://www.excelforum.com/showthread...hreadid=502232
--
Dave Peterson
Reply With Quote