Ask a question Report Reply to this topic

Create workbooks using a template and information from a table [Closed]

LinTruthy 2 Posts Thursday January 12, 2017Registration date January 12, 2017 Last seen - Jan 12, 2017 at 05:35 AM

Excel Ask a question Report Reply to this topic

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

Create workbooks using a template and information from a table
Create workbooks based on a given template using data in a table » Forum - Excel
Moving information from one table to another » Forum - Excel
Excel - Macro to create new workbook and copy data » How-To - Excel
Creating a letter template OpenOffice Writer » How-To - OpenOffice.org
Excel - A macro to create new workbook and copy data » How-To - Excel

Ask a question