Hi All,

First post here, so be gentle

I have created a workbook that will generate unique price lists for various customers. The idea I to eliminate any fields where there is not a price only to leave relevant products.

I have manually inserted page breaks where necessary and do not wish to change these.

When I apply a filter to remove all irrelevant fields (0, 'VALUE! and (Blanks)) and go to print there are sometimes many blank pages which represent the irrelevant fields filtered.

I am a novice when it comes to VBA so would appreciate any help you can provide.

Below is the link to download the file in full as it's too big to attach.

Link: https://max.mailbigfile.com/9fff4194.../listFiles.php

Thanks in advance.

Marc