Easy Excel Task - PDF Copy Paste

  • Status: Closed
  • Prize: $10
  • Entries Received: 7
  • Winner: yrs012

Contest Brief

Hi everyone,

I need to automate the following process:

1. Go to a website link given which contains a PDF file.
2. Find a specific section of a specific mutual fund.
3. Copy the entire section and paste it as Unicode in one column of a workbook.
4. Save the pages where the section started and where the section ended.

I am including an example:


1. The links to the PDFs are in the first tab. Each PDF have the same structure:
1.a The first page states the names of the mutual funds contained in the document.
1.b In the input file of the excel file you will find the specific mutual fund name wanted for each PDF link.
1.3 Each mutual fund has a section called "Schedule of Investments" or "COnsolidated Schedule of Investments" where you will find the data wanted.
2. Find the Consolidated Schedule of Investments section or the Schedule of Investments section (it will have different names depending the PDF file) of the specific mutual fund, copy paste the entire section into one column of a workbook as Unicode Text. Save the starting page and the ending page of the section where the data was copied.
3. Repeat the procedure for the other 2 examples. I left the page of the last example blank on purpose just to see if the program that you built is able to find the information without providing the page numbers.

I am attaching a file with an example, where you will find the input data needed to locate the information that should be copied in the first tab and in the second tab you will find the data from the PDF peasted in the workbook as Unicode Text.

Thank you!

Cristobal

Recommended Skills

Top entries from this contest

View More Entries

Public Clarification Board

  • FahmidaB
    FahmidaB
    • 1 year ago

    Hello cbucher, Check Entry #6

    • 1 year ago
    1. cbucher
      Contest Holder
      • 1 year ago

      Hi FahimdaB, I am checking the entries right now, yours looks well lets keep in touch in case I post more projects in the future. Cristobal.

      • 1 year ago
    2. FahmidaB
      FahmidaB
      • 1 year ago

      Thanks. Hope to work together in your coming projects. Have a good day. Fahmida.

      • 1 year ago
  • aeyelki2016
    aeyelki2016
    • 1 year ago

    Hello.

    • 1 year ago
    1. cbucher
      Contest Holder
      • 1 year ago

      Hello aeyelki2016, thank you very much for submitting, I am reviewing the entries right now, lets keep in touch for future projects.

      • 1 year ago
  • calderonmarcelo
    calderonmarcelo
    • 1 year ago

    Hi!

    • 1 year ago
    1. cbucher
      Contest Holder
      • 1 year ago

      Hola Marcelo! Gracias por participar, tu propuesta se ve interesante, mantengamos contacto para futuros proyectos!

      • 1 year ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!