So, I have a form for my employees where they can see their goals for the next year and some other payout related information.
I have the information for every employee in a seperate list (master data).
Now i want to generate a worksheet (even better a seperate file) for every single employee (that is one row in my master data) which looks like the form but the fields are filled with my values from the master data list.
How could I achieve this. Do I need to write a makro for this? Should I code it with C#?
Or is it possible just with Excel Functions (Preferred so my colleagues who cannot code can also work with it) ?
I hope this is the right place to ask this question.
Thank you in advance!