Ilmoita kilpailu

Easy Excel Task - PDF Copy Paste

Tila: Closed
Palkinto: $10
Vastaanotetut työt: 6
Voittaja: yrs012

Winner

Kilpailun tehtävänanto

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

Suositellut taidot

Winner

Ilmoita samanlainen kilpailu

Julkinen selvennystaulu

FahmidaB
- 7 vuotta sitten
Hello cbucher, Check Entry #6
- 7 vuotta sitten
1. Kilpailun järjestäjä
  - 7 vuotta sitten
  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.
  - 7 vuotta sitten
2. FahmidaB
  - 7 vuotta sitten
  Thanks. Hope to work together in your coming projects. Have a good day. Fahmida.
  - 7 vuotta sitten
aeyelki2016
- 7 vuotta sitten
Hello.
- 7 vuotta sitten
1. Kilpailun järjestäjä
  - 7 vuotta sitten
  Hello aeyelki2016, thank you very much for submitting, I am reviewing the entries right now, lets keep in touch for future projects.
  - 7 vuotta sitten
calderonmarcelo
- 7 vuotta sitten
Hi!
- 7 vuotta sitten
1. Kilpailun järjestäjä
  - 7 vuotta sitten
  Hola Marcelo! Gracias por participar, tu propuesta se ve interesante, mantengamos contacto para futuros proyectos!
  - 7 vuotta sitten