Results 1 to 3 of 3

Thread: Export to PDF (specific sheets) if cells in Input sheet are >0, if condition is met

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Newbie
    Joined
    Aug 2020
    Posts
    2
    Location

    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

    Attachment excel is below.

    Many thanks if anyone helps!
    Screenshot_1.jpg
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •