Macros to export filtered PDF from log

Hi,

I have attached a small version of the logs we use.It has hundreds of entries with revisions.Every week I have to filter this list and submit to management according to some criteria.



When I use Filter option, I have problem because Im not getting heading and title rows in Rows 2 and 4 to appear


Im trying to automate this process.
So im trying to get 3 buttons with assigned macros for printing and saving the PDF version to same folder for :

1. Full Log Entries
2. Filtered with items "LATEST" only in Column I
3. Filtered with items "LATEST" and "LATE" in I and J respectively

In all the PDFs,the heading and title row should also be printed.



Thanks in advance