Hello Everyone,
I needed to understand if my ask can be achieved through VBA.
So I have an excel sheet1 that has data from A1: U2000+ and we input the data under each heading.
and then I have to create an individual word document (below) for each name recorded in Sheet 1. So what I currently do is I enter the record in Sheet 1 and then again enter the same data in the required format in Sheet2 and then copy the data from Sheet2 to a word document. Doing this for 2000+ rows is a very time consuming and tedious task do we have an automated VBA option to fill the data in the desired format and save it in a word document.
If anyone can help me that would be a great relief
I needed to understand if my ask can be achieved through VBA.
So I have an excel sheet1 that has data from A1: U2000+ and we input the data under each heading.
and then I have to create an individual word document (below) for each name recorded in Sheet 1. So what I currently do is I enter the record in Sheet 1 and then again enter the same data in the required format in Sheet2 and then copy the data from Sheet2 to a word document. Doing this for 2000+ rows is a very time consuming and tedious task do we have an automated VBA option to fill the data in the desired format and save it in a word document.
If anyone can help me that would be a great relief