Convert pdf data to table

Originally Posted by stanleydgromjr

plumfin,

Detach/open workbook ReorgData - Convert pdf data to table - plumfin - EF760146 - SDG15.xlsm.

There seems to be a pattern to the groups of data (see Yellow alternating Green).

Are the headings/titles and their order, what you are looking for?

If not, then please change/move them around.

And, are all the titles accounted for?

Hi Stan, that is exactly what I am after, without the time of going through and highlighting each section. Is there anyway to get excel to split this into a database-type document, for easy mail merge?

Do mean the titles, that each section has each title? In that case, no - some of the entries are 10 rows, for example, some may have a little extra detail and may be 14. Sorry - if this is not possible, please don't spend your time on it! Many thanks though so far.
Kelly