How To Extract Table Data From a PDF / Copy/Paste to CSV

Hello,

My goal is to utilize pdf table data to populate a csv file. A simple copy & paste only serves to populate 1 column with all data. Ideally, I would like the columns to remain intact when copying and pasting over.

I can go line by line copying and transposing the desired rows into the original columns but would like to automate this process to better understand for loops in VBA.

Utilizing the Record Macro Functionality I have come up with this:

Please Login or Register  to view this content.

Administrative Note:

We would very much like to help you with your query, however your post does not comply with our guidelines

Please take a moment to review how to add code tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Guideline #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.

I have added the code tags for you today. Please take a few minutes to re-read our guidelines and rules that you agreed to when you joined and comply in the future.

Personally, I would bring the pdf into power query and then close and load PQ to a .csv file.