Hello,

I've got an Excel file where row 1. has questions in multiple collumns and rows 2-1000 have employees' answers to the questions. One row represents one employee and their answers.

I would like that every single employee would have their own Excel with the questions and their own answers. So, the first Excel would be row 1 and row 2, the second Excel would be row 1 and row 3 etc until the final Excel would be row 1 and row 999. How can I make this happen?

I would also like to name these Excels by the employee's name without having to manually input 999 Excel headlines. Would this be possible?

Thank you!