Export to PDF (specific sheets) if cells in Input sheet are >0, if condition is met
Dear, if anyone knows please help me to solve this problem, didn't find anywhere anything similar, and with VBA well im not quite good.
Here is description of problem:
Sheets (Report 1, 2, 3, and or 4) needs to be exported as one PDF if example condition on Input Sheet is >0
PDF document need to export on desktop
Document name needs to be as C18
By this example reports would be exported Report1, Report 3, Report 4.
Example condidtion is changing, so sometimes there will be exported just one report, sometimes all four of them
*If possible, to open email outlook, with saved PDF, with adress in sheet Input on cell C19, ready to be sent