|
Autofilter doesn't work
hi there! can someone tell me why the "autofilter" 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: http://www.excelforum.com/attachment.php?postid=4233 | +-------------------------------------------------------------------+ -- tombogman ------------------------------------------------------------------------ tombogman's Profile: http://www.excelforum.com/member.php...o&userid=30578 View this thread: http://www.excelforum.com/showthread...hreadid=502232 |
Autofilter doesn't work
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 |
Autofilter doesn't work
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 |
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 |
Autofilter doesn't work
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: http://www.excelforum.com/member.php...o&userid=30578 View this thread: http://www.excelforum.com/showthread...hreadid=502232 |
Autofilter doesn't work
"Dave Peterson" wrote in message
... If you select your range first, the autofilter should work against that 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. -- Regards Sandy with @tiscali.co.uk |
Autofilter doesn't work
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: "Dave Peterson" wrote in message ... If you select your range first, the autofilter should work against that 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. -- Regards Sandy with @tiscali.co.uk -- Dave Peterson |
| All times are GMT +1. The time now is 12:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com