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

Hi sintek,

Yes thats what Im trying to achieve with three buttons assigned macros
All three versions will be PDF in same folder
The title row and heading should be there in all three

Many thanks Sintek..

It'll take some time to understand this code..

Will get back to you after I get a hold..