This post is probably the most testing post I have ever done on this site so I'm keeping my fingers crossed that there is someone with the knowledge that can help. (please)
Right If I start with my requirement:
I have a very simple excel spread sheet that I would like to achieve the following:
1. Create quarterly invoices automatically in a separate excel spread sheet that are saved to the right customer directory.
2. Print the newly created invoices automatically (2 copies of each) quarterly (not sure if this would be done via a scheduled task)
3. There are 2 different invoices a)management fee b)company secretary fee. Each will be a different invoice however no all companies have the company secretary invoice.
I have attached a copy of the data source template and a copy of the template for the invoice.
I will be completely honest I know absolutely zero where it comes to VB scripts and Zero where it comes to excel macros and how they work. It may be a case that another technology would be better but hey I guess that's why I'm asking the question. Merlin-Management-fees.xlsx
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.