Autofiltering multiple tables on a spreadsheet
 

I downloaded a sample to do list spreadsheet from the Microsoft templates
section. It uses autofilter to create the drop down filter for "done" items.
It filters the three orginal tables & headers that came with the template.
That is to say that it retains and shows the headers of even empty tables
which is what I want. I then copied and pasted a fourth table, but the
autofilter really only affects the original three. None of these table are
yet very long (average 24 rows each), but I wish to expand beyond three
tables with headers.

If you can, you can quickly see the template at:

http://office.microsoft.com/en-us/te...CT062640421033

Paul

After you have copied say Table 3 and renamed it Table 4 go to
DataFilterAutofilter and uncheck it.

Now select from Table 1 "Done" cell to bottom of Table 4

DataFilterAutofilter. Check it on.

Enter a date in Table 4 "Date due" and enter an "a"(no quotes) in the "done"
column next to that date.

You should get a checkmark.

Try your Filter now. Click on the Autofilter arrow and select "non blanks".


Gord Dibben Excel MVP

On Tue, 25 Jan 2005 14:15:01 -0800, "Paul"
wrote:

I downloaded a sample to do list spreadsheet from the Microsoft templates
section. It uses autofilter to create the drop down filter for "done" items.
It filters the three orginal tables & headers that came with the template.
That is to say that it retains and shows the headers of even empty tables
which is what I want. I then copied and pasted a fourth table, but the
autofilter really only affects the original three. None of these table are
yet very long (average 24 rows each), but I wish to expand beyond three
tables with headers.

If you can, you can quickly see the template at:

http://office.microsoft.com/en-us/te...CT062640421033