Create workbooks using a template and information from a table

Ask a question LinTruthy 2Posts Thursday January 12, 2017Registration date January 12, 2017 Last seen
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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!