I have a “Template.xlsx” excel workbook with the right layout and formatting. I also have another workbook with all the workers data. I need to make an excel workbook for each person witht heir own data using the Template’s layout.
So my idea was to copy a template per person, fill it and save it with changing the name to a persons id. So that I’d have a folder with a bunch of workbooks for each person and the original Template.xlsx file should still be empty.
I can only find how to copy an excel sheet though, not the whole workbook.
Is it possible at all?