I am not well acquainted with macro's but am looking for a quicker solution to saving multiple PDF's from a single excel sheet.
The excel sheet extracts information from multiple other excel sheets to create a summary per client per orchard of essential data.
Currently I have to copy and paste the client name and Orchard number for every orchard and then SAVE and name the PDF.
This must be done for over 1000 PDF's and needs to be updated regularly so is very time consuming.
I would also like to be albe to print a hardcopy of each sheet using a Macro if possible. Currently printing follows the same procedure as saving PDF's.
The excel sheet extracts information from multiple other excel sheets to create a summary per client per orchard of essential data.
Currently I have to copy and paste the client name and Orchard number for every orchard and then SAVE and name the PDF.
This must be done for over 1000 PDF's and needs to be updated regularly so is very time consuming.
I would also like to be albe to print a hardcopy of each sheet using a Macro if possible. Currently printing follows the same procedure as saving PDF's.