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 todays 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

  • GoCavs
    replied
    As long as its fits on one page well be good.

    Leave a comment:


  • GCExcel
    replied
    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

    Leave a comment:


  • GoCavs
    replied
    Yes. I do. Will send now. Thanks!!

    Leave a comment:


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

    Leave a comment:


  • GoCavs
    replied
    Perfect!! thank you!

    Leave a comment:


  • GCExcel
    replied
    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.

    Leave a comment:


  • GoCavs
    replied
    Thank you GC!!!

    Leave a comment:


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

    Leave a comment:


  • GoCavs
    replied
    pre-payment sent

    Leave a comment:

Working...
X