Split Data from One sheet into multiple sheets and email

Question

Hi,

I hope some one can help. I want to split data into multiple sheets, I want to copy across Cells A4 to Q4 & A5 to Q5, then add the individual employee details. Below is the raw data and the image below is what I want to create for each individual employee.

Below is what I would like to have created for each employee on a separate worksheet, and then automatically email the information to each indvidual employee.

I appreciate any help with solving my query.

Answer 1

Hi,

You may refer to my solution - Split data into multiple tabs.

Hope this helps.