Forum Discussion
Can Excel link with Adobe doc
If you have managed to insert the data / values from the pdf document into the worksheet, with whatever option, it is possible to accomplish your project without problems with the IF function or whatever other function is necessary. However, the data must first be available on the worksheet in the cells you want.
If you want you to be able to compare the data directly from the PDF document and transfer it to the worksheet, it is not possible to do with a simple function.
The first step is always to get the data / values / text on the worksheet beforehand and then it is possible to use whichever function.
I do not know whether it is possible with the full version of Adobe Pro DC, or with any other third-party software, you would have to do some research on the Internet.
With the right Office version (where it is possible to import data from pdf - please see the link that I sent you before) you could transfer / import the data on the Excel sheet from the pdf document and use a macro (VBA Code) or cell formulas they could accomplish your project.
I wish you continued success with Excel
Let's take it to the next level. Is it possible to use if function so I can look up what needs to come back into my excel sheet? So, the s/s looks to text in PDF, if match, returns value along the same row.
If you have managed to insert the data / values from the pdf document into the worksheet, with whatever option, it is possible to accomplish your project without problems with the IF function or whatever other function is necessary. However, the data must first be available on the worksheet in the cells you want.
If you want you to be able to compare the data directly from the PDF document and transfer it to the worksheet, it is not possible to do with a simple function.
The first step is always to get the data / values / text on the worksheet beforehand and then it is possible to use whichever function.
I do not know whether it is possible with the full version of Adobe Pro DC, or with any other third-party software, you would have to do some research on the Internet.
With the right Office version (where it is possible to import data from pdf - please see the link that I sent you before) you could transfer / import the data on the Excel sheet from the pdf document and use a macro (VBA Code) or cell formulas they could accomplish your project.
I wish you continued success with Excel
- I requested an upgraded Adobe package from IT as I was not able to convert the PDF to excel. Next steps for me are: PDF to excel to Access. Link, program, LOCK, and train. Badabing badaboom!
- I am pleased that you came to a solution :).
Have fun with Excel ... the most beautiful invention since there was chocol ... uh Microsoft :)).- thanks. Excel is so much fun! It's sad and I get frustrated when others don't use it to it's potential. However, I do end up spending hours and hours searching and learning, essentially not on my original task. 😉