need macro to transpose data from excel to MS word.

[winmaxservices2]

Hi,
I am the basic learner and beginner of excel.
I need macro to transpose data from excel to MS word. I have attached two files. 1st Excel file (Student list) and second word file(Template).
I want to Copy a data (Only selected given column in word file) from excel and to paste in word as per the format in attached word template file.
We keep adding record in excel file. So the list will be large. in "student list" file I should get an option to enter required record's serial number to copy to word template.

Example. as given in attachment "student list" there are 15 records. But in "Template" file only four records, i.e. serial number 1,3,10 and 14 has been pasted as template as per our requirement.

Hence after updating the student list file, while running the macro, we should get an option to enter a required serial number (records to be be pasted in template file) like, 2,3,15,101 , etc to copy the selected records.

Please help.

[arlu1201]

Hello winmaxservices2,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.