Filter / Titles Rows not printing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)


Louise said:
Please help!
I need some more enlightment. I have not been able to make a filter work
Click to expand...
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.
 
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)


Louise said:
That was the first thing I made sure I had the correct ranges to print. I
Click to expand...
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?
 
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
 
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)



Debra Dalgleish said:
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
Click to expand...
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?
 
Back
Top