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