Hello,

I am trying to write a Macro or VBA code that will allow me to take data from a main page, copy it to a template, create a worksheet based on the completed template, and continue this process based on the amount of data listed on the main page.

Basically the sheet contains the following data:
Date
Employee Name
Register Number
Area
Over/Short Amount

This information will then get transferred to the template, which is a Disciplinary Warning for an employee. Upon the template being completed, a worksheet will then populate & be renamed to the employees name.

I have attached the spreadsheet that I am using.

Any help would be greatly appreciated!