Filter multiple tables on the same sheet

Excel 2000.

I have three tables that have roughly 50 lines of date apiece on one sheet.
At the bottom of each table is a summary total of the prior 50 lines.

I want to make a filter that will filter all three tables at the same time
and keep my formatting. Example, if I choose the name “John” and that value
appears in 10 lines of each table, then I would like to 1) Only show the 10
lines per table 2) sum/subtotal the value of those 10 lines, 3) keep my 3-5
blank lines in between each table.

I tried to do this with an auto filter, but it doesn’t like the fact that I
have 5-10 blank lines in-between my tables. I know if I just created one big
table then this would not be an issue, but the data is different and I do not
want one big 150 line table.

I appreciate your advice on this topic.

Assuming that the tables are all in the same columns (or at least the name
is) and that the value in that column for your totals is blank, you could use
Auto Filter. Select the entire column and choose Auto Filter. Then when you
filter, choose Custom. Choose the value you want for the first option. Click
on Or, make it Equal and leave the value empty.
To get the sum to show what you want, use subtotal instead of sum.

"John" wrote:

> Excel 2000.
>
> I have three tables that have roughly 50 lines of date apiece on one sheet.
> At the bottom of each table is a summary total of the prior 50 lines.
>
> I want to make a filter that will filter all three tables at the same time
> and keep my formatting. Example, if I choose the name “John” and that value
> appears in 10 lines of each table, then I would like to 1) Only show the 10
> lines per table 2) sum/subtotal the value of those 10 lines, 3) keep my 3-5
> blank lines in between each table.
>
> I tried to do this with an auto filter, but it doesn’t like the fact that I
> have 5-10 blank lines in-between my tables. I know if I just created one big
> table then this would not be an issue, but the data is different and I do not
> want one big 150 line table.
>
> I appreciate your advice on this topic.
>