Hi all
i have a large sheet when the workbook is finally printed at the end of each section there is a small recap that enables the end user to stamp section is complete for a paper copy to keep.
My problem is if i preformat this section it looks completely differnt to the rest of the worksheet with some boxes that are empty the problem is when i run an advanced filter of unservacable parts if that section is there the filter stops at the end of the first section if i delete these 6 rows then the advance filter will run all the way to the end of the sheet.
is there a way i can exclude these sections from the filter or does anybody have any other ideas?
LKind regards tim
Bookmarks