Announcement

Collapse
No announcement yet.

$75 USD: Create multiple PDF reports from one sheet (urgent)

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • $75 USD: Create multiple PDF reports from one sheet (urgent)



    I have a request is to create individual PDF files for every unique name in column A of a sheet in the attached file. I was think the macro logic would be as follows:

    NOTES:
    Worksheet = Sheet1
    Header Row = Row 1 (need on each PDF report)
    Data Range = A:E
    Max rows per Name = 58

    LOGIC:
    Look in Column A (Full Name) and for each unique name, create a PDF file with the Header along with each row of data. The folder location for the PDF files would be “C:\Users\jstriker\Documents\Alix Partners\PMO\PDF”. I need each PDF to be on a single page (since the max rows are 58 we should be good). Then after the 1st name report is created, then search for the 2nd unique name is Column A and repeat the PDF process, then repeat with names 3, 4, 5…... The attached is a test file with 2 names but the real file with have about 200 unique names. Also, could the PDF file names be customized from the Full Name value in column A and then add today’s date (John doe – 03 29 19.pdf).

    The request is time sensitive and hope to have a solution ASAP. Thank you and reach out with any ?'s.
    Attached Files

  • #2
    pre-payment sent

    Comment


    • #3
      Hello,
      I will look at your request and let you know if I have any questions.

      Comment


      • #4
        Thank you GC!!!

        Comment


        • #5
          All is clear - no questions - I'll send you solution as soon as I can. Should be ok before end of the day if that's fine with you.

          Comment


          • #6
            Perfect!! thank you!

            Comment


            • #7
              Well it was faster than I thought. I have solution ready for you.
              You already have my payment details... correct?

              Comment


              • #8
                Yes. I do. Will send now. Thanks!!

                Comment


                • #9
                  Payments received.... Thanks.
                  Here's the file. I did it rapidly and didn't spent too much time on the formatting.

                  Let me know if you have any questions or comments.

                  Thanks,
                  Attached Files

                  Comment


                  • #10


                    As long as it’s fits on one page we’ll be good.

                    Comment

                    Working...
                    X