We would like you create system/layout where the information we input into excel rows would allow us to create an invoice based on that information. The template layout would be predetermined and the macros in our rows would be inserted in the specific cells in the invoice. We are looking for a simple solution that allows us to save time and easily create invoices by selecting a specific row that has all the information needed to create the invoice. We also need the invoice to be in finnish so we would need translate the established template to finnish.
In the file attached you will find our invoice sample. All the cells that are green have to always remain the same format. The cells that are red need to get their value from one row in another excel spread sheet.
We also welcome other solution if you have familiarity with the problem we are trying to solve. The other excel is our suggestion of the format we would manually input information in.