software

hi there!

can someone tell me why the quot;autofilterquot; isn't working in my worksheet
(see attachment). And is there a way to get it working?

thanks in advance!

Tom -------------------------------------------------------------------
|Filename: autofilter.zip |
|Download: www.excelforum.com/attachment.php?postid=4233 |
-------------------------------------------------------------------

--
tombogman
------------------------------------------------------------------------
tombogman's Profile: www.excelforum.com/member.php...oamp;userid=30578
View this thread: www.excelforum.com/showthread...hreadid=502232Autofilter stops at the first blank row.

--
HTH

Sandy
with @tiscali.co.ukquot;tombogmanquot; gt; wrote
in message ...
gt;
gt; hi there!
gt;
gt; can someone tell me why the quot;autofilterquot; isn't working in my worksheet
gt; (see attachment). And is there a way to get it working?
gt;
gt; thanks in advance!
gt;
gt; Tom
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: autofilter.zip |
gt; |Download: www.excelforum.com/attachment.php?postid=4233 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; tombogman
gt; ------------------------------------------------------------------------
gt; tombogman's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30578
gt; View this thread: www.excelforum.com/showthread...hreadid=502232
gt;

Sandy Mann Wrote:
gt; 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: www.excelforum.com/member.php...oamp;userid=30578
View this thread: www.excelforum.com/showthread...hreadid=502232tombogman,

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.ukquot;tombogmanquot; gt; wrote
in message ...
gt;
gt; Sandy Mann Wrote:
gt;gt; Autofilter stops at the first blank row.
gt;
gt; any solution to this? another way to sort my data, maybe without
gt; autofilter?
gt;
gt; thx,
gt; T.
gt;
gt;
gt; --
gt; tombogman
gt; ------------------------------------------------------------------------
gt; tombogman's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30578
gt; View this thread: www.excelforum.com/showthread...hreadid=502232
gt;
If you select your range first, the autofilter should work against that
selection--even if there are empty rows/columns.

Sandy Mann wrote:
gt;
gt; tombogman,
gt;
gt; You need a continuous stream of data connected to the rows. Insert a new
gt; column - say column A. Expand all you groups and then in A1 place any entry
gt; and copy it down the full length of your data then hide column A again.
gt;
gt; The Autofilter should then work.
gt; --
gt; HTH
gt;
gt; Sandy
gt;
gt; with @tiscali.co.uk
gt;
gt; quot;tombogmanquot; gt; wrote
gt; in message ...
gt; gt;
gt; gt; Sandy Mann Wrote:
gt; gt;gt; Autofilter stops at the first blank row.
gt; gt;
gt; gt; any solution to this? another way to sort my data, maybe without
gt; gt; autofilter?
gt; gt;
gt; gt; thx,
gt; gt; T.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; tombogman
gt; gt; ------------------------------------------------------------------------
gt; gt; tombogman's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=30578
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=502232
gt; gt;

--

Dave Peterson


Thx Sandy, that's the solution, it works great!

Dave, thanks for your answer but it doesn't seem to work ...

thx again for answering that fast!

T.--
tombogman
------------------------------------------------------------------------
tombogman's Profile: www.excelforum.com/member.php...oamp;userid=30578
View this thread: www.excelforum.com/showthread...hreadid=502232quot;Dave Petersonquot; gt; wrote in message
...
gt; If you select your range first, the autofilter should work against that
gt; selection--even if there are empty rows/columns.

I actually tried that before posting but it failed. I did not realise that
you had to select the range BEFORE applying the autofilter. The OP had the
autofilter already on so it failed when I just selected the range and tried
selecting a filter it failed.--
RegardsSandy
with @tiscali.co.uk

I do my best never to let excel guess the range to sort/filter/chart/pivottable.

And I've never seen any of those fail if I select the range first--no matter how
many gaps there were.

I have no idea why it didn't work for tombogman. I'd suggest that he remove the
filter and try it again.

Sandy Mann wrote:
gt;
gt; quot;Dave Petersonquot; gt; wrote in message
gt; ...
gt; gt; If you select your range first, the autofilter should work against that
gt; gt; selection--even if there are empty rows/columns.
gt;
gt; I actually tried that before posting but it failed. I did not realise that
gt; you had to select the range BEFORE applying the autofilter. The OP had the
gt; autofilter already on so it failed when I just selected the range and tried
gt; selecting a filter it failed.
gt;
gt; --
gt; Regards
gt;
gt; Sandy
gt;
gt; with @tiscali.co.uk

--

Dave Peterson