Using VBA to copy and paste from pdf to excel by specific keywords

[jk16]

Hi,

I am very new to VBA and I want to copy and paste text from pdf to excel using VBA and match it in specific cells on my spreadsheet. If possible, I was hoping to copy the sections by searching specific section numbers that lie beneath the desired section I want copied. For example:
“Desired text to be coped”
Section number: 12.1

I then want to paste this text in specific cells of my spreadsheet that also match the same section number. Any advice on how to do this? Any help would be appreciated! Thanks!

 

[Automatrix]

Not VBA, but you may want to look into Power Query, which is able to read from pdf files.