bobbybrown
Board Regular
- Joined
- Apr 17, 2015
- Messages
- 121
Hi,
I'm trying to get my accounts in order here and as such I have a folder full of invoices, all exactly the same layout as I use a template file that I made to create each invoice.
What I am trying to figure out is:
Is there a way that I can create a master sheet in excel with the field name across the top such as invoice number, date, name, product, price, transaction id then have the master sheet scan my folder and pick the information out of every invoice sheet automatically using a macro and populate the master sheet as a big list of sales?
Some people have more than 1 product so not sure how this could be handled
I could then autosum the total price so I can keep a running total of invoice totals.
If there was a way to re-run this periodically but have the macro only read new files that would be perfect too but I'm not sure if something like this could be done.
I guess first I am looking to see if this is possible and if so the best way to go about it.
Many thanks to you for reading my post!
I'm trying to get my accounts in order here and as such I have a folder full of invoices, all exactly the same layout as I use a template file that I made to create each invoice.
What I am trying to figure out is:
Is there a way that I can create a master sheet in excel with the field name across the top such as invoice number, date, name, product, price, transaction id then have the master sheet scan my folder and pick the information out of every invoice sheet automatically using a macro and populate the master sheet as a big list of sales?
Some people have more than 1 product so not sure how this could be handled
I could then autosum the total price so I can keep a running total of invoice totals.
If there was a way to re-run this periodically but have the macro only read new files that would be perfect too but I'm not sure if something like this could be done.
I guess first I am looking to see if this is possible and if so the best way to go about it.
Many thanks to you for reading my post!