Create workbooks using a template and information from a table

Closed
LinTruthy Posts 2 Registration date Thursday January 12, 2017 Status Member Last seen January 12, 2017 - Updated by LinTruthy on 12/01/17 at 05:40 AM
Please help me out,
an example of data I have on sheet two
Name bio Chem phy lug
John 40 60 50 20
Luke 70 50 30 77
Eric 80 90 89 60
I want to create a workbook per name using a template on sheet one . The name should be in c11, bio score in D17, phy score in d 18, Chem score in d19 ..., each workbook name should correspond to the name in c 11. and the workbooks saved in c :\ reports \ .
Any help will be appreciated. Thnx in advance
Related: