Filter / Titles Rows not printing

[Louise]

Please help
I need some more enlightment. I have not been able to make a filter work properly. I have rows 1 through 20 that need to print every time I filter. I am filtering by dates and they are in cells A21 through A200. When I give the parameters for the filter, it does perform the action but cuts several rows from the top (Rows 15 to 20) and I am left with incomplete titles
Any ideas
Thanks for your assitance
Louis

 

[Arvi Laanemets]

Hi

File.PageSetup.Sheet - set 'Rows to repeat at top' to $15:$20


--
Arvi Laanemets
(When sending e-mail, use address arvil<At>tarkon.ee)

Please help!
I need some more enlightment. I have not been able to make a filter work

properly. I have rows 1 through 20 that need to print every time I filter.
I am filtering by dates and they are in cells A21 through A200. When I give
the parameters for the filter, it does perform the action but cuts several
rows from the top (Rows 15 to 20) and I am left with incomplete titles.

 

[Arvi Laanemets]

Hi

You do use autofilter, do you? Select the range you want to filter,
including row 20 (as header), and set autofilter on.


--
Arvi Laanemets
(When sending e-mail, use address arvil<At>tarkon.ee)

That was the first thing I made sure I had the correct ranges to print. I

think the problem is that when I insert the filterit is confusing the titles
and it is filtering those other rows as "dates not within the requested
range". What instruction should I include so the filter is not set on row 14
but on row 21?

 

[Debra Dalgleish]

There should be a blank row between the table and the other data on the
worksheet, and the table headings should be in one row, not several.

So, based on your description, row 19 should be blank, your table
headings should be in row 20, and the dates should start in row 21

 

[Arvi Laanemets]

Hi

With preselected range is there no need for empty row. Of course when you
add new entries afterwards, then you have to include some amount of empty
rows into preselected range, or you have to reset the autofilter every time
when new rows are added.


--
Arvi Laanemets
(When sending e-mail, use address arvil<At>tarkon.ee)

There should be a blank row between the table and the other data on the
worksheet, and the table headings should be in one row, not several.

So, based on your description, row 19 should be blank, your table
headings should be in row 20, and the dates should start in row 21

I think the problem is that when I insert the filterit is confusing the
titles and it is filtering those other rows as "dates not within the
requested range". What instruction should I include so the filter is not set
on row 14 but on row 21?