krokodilizm
New Member
- Joined
- Feb 3, 2016
- Messages
- 20
I have an Excel template for invoicing manually and I'd like to automate the key variables, i.e. date, reference, amount and description.
I have these variables in a separate Excel file
<tbody>
</tbody>
How can I create a code to run through this list and create for example 50 unique invoices as Excel files and post the in a directory? Maybe one can give me the direction to create the VBA code myself. I doubt there is a ready template to use.
Thanks.
I have these variables in a separate Excel file
Date | Reference | Amount | Description |
1/1/2016 | Inv 2016-001 | 7500 | Fees etc |
<tbody>
</tbody>
How can I create a code to run through this list and create for example 50 unique invoices as Excel files and post the in a directory? Maybe one can give me the direction to create the VBA code myself. I doubt there is a ready template to use.
Thanks.