Hello,
I have an excel file has 90 plus rows of data with each row having data for one country. I need to update a word doc (report) with some columns of data from the excel file (Eg. col. A, Col C, Col E). The data is in text, numbers, percentage format. Once the doc is updated I need to save it as new doc. with the file name as the country name(Col. A has country name). I am new to VBA, can you please help get started. Should I be writing the code in Excel or Word doc. to start with?
Thank you very much for your help.
I have an excel file has 90 plus rows of data with each row having data for one country. I need to update a word doc (report) with some columns of data from the excel file (Eg. col. A, Col C, Col E). The data is in text, numbers, percentage format. Once the doc is updated I need to save it as new doc. with the file name as the country name(Col. A has country name). I am new to VBA, can you please help get started. Should I be writing the code in Excel or Word doc. to start with?
Thank you very much for your help.