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