anuradhagrewal
Board Regular
- Joined
- Dec 3, 2020
- Messages
- 87
- Office Version
- 2010
- Platform
- Windows
Hi
I have this document with all the students marks for a given term. The same can be accessed here
What I am trying to figure out that if there is a way in excel that the output of the data (from the sample.xlsx) be written by a macros in a word file (output.docx) in this format given below
Also I am looking to have a separate word document created for each entry with the student name ,class and section.
For eg I get a marksheet of lets say Alex then can the word document be named like "Alex-XII-A.docx"
Please please help me out.
Best Wishes
Anuradha
I have this document with all the students marks for a given term. The same can be accessed here
SAMPLE.xlsx
Sheet1 ADMISSION NO,STUDENTS NAME,FATHER'S NAME,MOTHER'S NAME,DATE OF BIRTH,CLASS,SECTION,HOUSE,ATTENDANCE,TERM 1,TERM 2 Subject 1,Subject 2,Subject 3,Subject 4,Subject 5,Subject 6,Subject 7,Subject 8,Subject 1,Subject 2 233,Alex,Joe,Sandra,9/12/2011,XII,A,BLUE,57,47,45,49,56,46,41,42,44,52,58 242
docs.google.com
What I am trying to figure out that if there is a way in excel that the output of the data (from the sample.xlsx) be written by a macros in a word file (output.docx) in this format given below
output.docx
docs.google.com
Also I am looking to have a separate word document created for each entry with the student name ,class and section.
For eg I get a marksheet of lets say Alex then can the word document be named like "Alex-XII-A.docx"
Please please help me out.
Best Wishes
Anuradha
Last edited by a moderator: