Good day everyone,
I have limited experience with macros, been a few years since I utilized them. I am being tasked with finding a way to use a macro to extract specific data from a PDF and have it populate into specified blocks of an excel workbook. My goal is to create and use a macro to eliminate the process of manually copying only specific data from a PDF and manually pasting it into specific blocks on an excel spreadsheet.
Part 1 - I have attached a snippet from a PDF showing that I want to extract the debit and credit amounts from Entity 0033, Account # 8050065 as highlighted.
Part 2 - I need the extracted amounts from Part 1 to populate the green highlighted cells on the excel spreadsheet.
Thank you kindly as any help or direction is greatly appreciated.
I have limited experience with macros, been a few years since I utilized them. I am being tasked with finding a way to use a macro to extract specific data from a PDF and have it populate into specified blocks of an excel workbook. My goal is to create and use a macro to eliminate the process of manually copying only specific data from a PDF and manually pasting it into specific blocks on an excel spreadsheet.
Part 1 - I have attached a snippet from a PDF showing that I want to extract the debit and credit amounts from Entity 0033, Account # 8050065 as highlighted.
Part 2 - I need the extracted amounts from Part 1 to populate the green highlighted cells on the excel spreadsheet.
Thank you kindly as any help or direction is greatly appreciated.