Forum Discussion
Pulling selected data from multiple invoices to an excel sheet using VBA
Hello Guys, 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 ? Thanks
Power Query might be an option. A sample would be excellent.
You're going to need VBA scripted for this one because of the arrangement of the invoices. It's do-able. Other factors that need to be taken into consideration for the script.
- The location of the files
- Arrangement of the invoice data - are the values you need always in the same cells?
VBA could open the workbooks, fetch the data and write it to the destination workbook then close it. Repeat for each workbook.
