I did some digging in search to get me started but came up empty. Here's what I'd like to do:
- Click on a folder containing an unknown number of PDF files. Each PDF file is exactly the same layout (invoices from a subcontractor).
- Activate a macro to copy specific information into a set of rows (one per PDF file) in numbers. Just client name, and invoice total.
- Bonus if we can automatically sum the invoice amounts in numbers.
I don't even know where to start with this macro. I've not done file "handling" before and I have no idea if what I'm asking is even possible. If anyone has ideas or can point me in a direction to start messing around with this I would greatly appreciate it.
Here is some sample data. A spreadsheet and an example invoice.
Sample Data.zip (145.0 KB)