Create workbooks based on a given template using data in a table [Closed]
LinTruthy2
Posts Thursday January 12, 2017Registration date
January 12, 2017
Last seen
-
Jan 12, 2017 at 01:07 AM - Latest reply: Ambucias51209
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 \ .
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.
