Pulling selected data from multiple invoices to an excel sheet using VBA

Question

Hello Guys,&nbsp;Is it possible to pull selected data from multiple invoices to an excel sheet through VBA ? If so kindly help me out with the same ?&nbsp;Thanks

mathetes · Answer

You are far more likely to get a helpful response if you upload samples of the invoices you'd be working with. Presumably they are electronic, but are they PDF, Word, Excel, something else? Are they all consistent in format?
And if you already have an Excel sheet into which you're expecting to place the data, upload a sample of that too.

patrick2788 · Answer

Karthik0203&nbsp;Power Query might be an option.&nbsp; A sample would be excellent.

patrick2788 · Answer

Karthik0203&nbsp;You're going to need VBA scripted for this one because of the arrangement of the invoices.&nbsp; It's do-able.&nbsp; Other factors that need to be taken into consideration for the script.&nbsp;- The location of the files- Arrangement of the invoice data - are the values you need always in the same cells?&nbsp;VBA could open the workbooks, fetch the data and write it to the destination workbook then close it.&nbsp; Repeat for each workbook.

karthik0203 · Answer

Himathetes.&nbsp;Sorry for the late response, i have hereby uploaded two sample invoices (PDF) and an sample excel sheet which consists of the expected data which is numbered from 1 to 8.&nbsp;Thanks in advance.