Create workbooks based on a given template using data in a table [Closed]

LinTruthy 2 Posts Thursday January 12, 2017Registration date January 12, 2017 Last seen - Jan 12, 2017 at 01:07 AM - Latest reply: Ambucias 51209 Posts Monday February 1, 2010Registration dateModeratorStatus April 27, 2018 Last seen
- Jan 12, 2017 at 05:05 AM
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 \ .
See more 

1 reply

Ambucias 51209 Posts Monday February 1, 2010Registration dateModeratorStatus April 27, 2018 Last seen - Jan 12, 2017 at 05:05 AM
0
Helpful
Greetings,

Please, bare in mind that CCM is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Hence we request that CCM forum users show mutual respect. Therefore, when asking for assistance, please be courteous, as for elsewhere in similar circumstances in every day society when asking for help. (Usually, how would someone ask for help? i.e. please, thank you, appreciate, grateful, etc.)

Being courteous will also increase your chances of getting the help you need.

http://ccm.net/contents/948-terms-of-use-for-ccm-respect-for-others

Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.

Moderator