Hello,
I am a fully certified Official Microsoft Office Specialist who works as a data analyst, specialising in SQL, Excel and Access. I can create interactive dashboards, databases, and custom formulas / programs for within Microsoft Office products. I can offer a wide range of business solutions such as automatic emailing, KPI’s, database creation and workflow automation, along with other services such as adhoc reporting.
for your project, this could be done through a VBA macro, a table with your products and then this would create an invoice based on an order sheet. the macro would look into the order sheet for products bought by the customer, then cross-reference the product sheet for pricing, and then create an invoice based on the merge of these details.
I am always free for a chat after the project for any changes that you need.
Feel free to ask me any questions!
Kind regards,
Arran Mercer