PDF Excel manual lookups getting tiring.

There are so many possible scenarios when it comes to "tables" in a PDF. A table may have been created as columns in another program such as Word or other word processor, it may have been created in a spreadsheet or by other means. If you are lucky, a program like Acrobat might be able to export the tables in Excel format. If that isn't possible, there are Optical Character Readers (OCR) that will recognize table structure in a selection and actually create a table for you.

Probably the best would be to get the source of the data to supply you with Excel tables. It is worth a try to get the data in a useable format directly from source.

Once you have a reliable method of getting your data into Excel, if you are having problems performing the tasks that you perform with the data, you could post a question with a sample workbook so that we could try and find a solution for you.

Hi, welcome to the forum

I posted this on another excel forum too, hope that's not against the rules!

Actually, while there is no rule against posting on other forums (called cross-posting), there is a rule that requires you to provide a link to the other post/s. (Rule 8)


Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read his[/URL] to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

Regarding your question/s - this forum has the capability for you to upload sample workbooks so members can see what you are working with, and so you can show what you want.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Hi Phoebe,

It's too bad that you didn't randomize the input and carry that through to the output

I had a gig recently where they sent me the input as PDF but created on a Mac.

I had to convert to Word then copy paste the word flle into Excel. (I put my method into the Tips and Tutorials forum).

Sorry, the link did not come through in my previous post...

this

I can't say that I understand what you are wanting to match. You can use the filter found on the Data tab to filter the data on any of the columns. For example, you can filter on Policy Number, Insurer code etc and retrieve only the records that are appropriate to the filter.