I would like to create an something in excel where i enter data and make documents required selections in “sheet1”, click go, and the “documents” will be generated a seperate sheets, etc…. and these are created on basis the date entered and the required documents selected – the doc templates will already be created in the background but the data is then pulled in to the selected docs.
i.e “sheet 1” i select that i need 3 documents, say an invoice, certificate of origin, and a packing list, and i enter the relevant detais, click go and these documents are created.
i have seen something like this done in excel before, but have no idea where to start/how to create this
Any help will be appreciated!