Hi,

Hoping someone can help me please?

I am looking to have a macro button to print specific invoices. Basically I have a tab called 'invoices' which stores page 1 - however many # pages, 1 unique invoice on each page. The details on the invoices are taken from another tab depending on the region e.g. Name of person to invoice comes from 'region1!A15'.

Anyway I would like to have a macro button that you can press which prints out all the invoices which comes from Region 1 another button for Region 2, another for Region 3 etc.

Thanks