New to VBA, need help with an automated process for work

[vba_newbieUAE]

Hi,

So I'm new to the world of excel, and wanted help making a process of macros in VBA that'll automate the below process

- read all the numbers on a PDF file
- read all the numbers in the current worksheet
- highlight all the numbers that match in the current worksheet with the numbers in the PDF file (its a financial position) in green
- highlight all the number that were not found in the pdf file, in red
- send a message when done saying crosscheck complete

and

- highlight matching amounts with another sheet in another workbook in blue
- if we can also automate the download directly from sap for the other workbook that would be great too

Thank you guys

 

[Automatrix]

Welcome to the world of Excel. Since you will be drawing data from pdf files and SAP, you should look into Power Query, which may very well be able to do what you want without VBA.