Re: Can't get autofilter applied to every row

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Don Guillett (donaldb_at_281.com)
Date: 03/17/04 

Date: Tue, 16 Mar 2004 19:29:43 -0600

If you don't have more than 1000 rows try adding any value such as xxxxxxxx
to the LAST row. 

-- 
Don Guillett
SalesAid Software
donaldb@281.com
"SSpade19 >" <<SSpade19.138fqj@excelforum-nospam.com> wrote in message
news:SSpade19.138fqj@excelforum-nospam.com...
> thanks Don
>
> but i think what i'm trying to do should be much simpler. I just use
> the autofilter option. Basically I selected one row that contains all
> the columns that will serve as my filter criteria, then hit
> data/autofilter. The filter should then work on the entire spreadsheet,
> but what i find is that especially after copy/pasting data from other
> sheets, the filter will only work on the first rows.
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

Relevant Pages

  • Re: is there a way to?
    ... "Don Guillett" wrote: ... Microsoft MVP Excel ... Somehow I need to set the filter on each page simultaneously to match ... I.e., I want to select a filter criteria on one worksheet, and have it ...
    (microsoft.public.excel.programming)
  • Re: Can a spreadsheet be too complicated for the computer to run
    ... computers with dual core processors and as a comparrison timed a filter, ... "Don Guillett" wrote: ... Microsoft MVP Excel ...
    (microsoft.public.excel.misc)
  • Re: Download problems with emails with special charaters
    ... I tried to filter on ... trhe topic and special characters, ... >Don Guillett ... >Only solution is to delete the problem emails with web ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Advanced filtering
    ... the macro recorder is your friend. ... ' Macro4 Macro ... ' Macro recorded 7/2/2006 by Don Guillett ... I can get the program to filter using ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Tagging a column
    ... maybe data>filter>advanced filter ... Don Guillett ... I have set up a spreadsheet with a simple sheet1to show each ... i'm a real novice and i think i have bitten off more than i can chew.. ...
    (microsoft.public.excel.worksheet.functions)