Hi there everyone.
I have 274 Word documents which were created by running a command on our Linux ZenWorks server. The command created a new Word Document for every software bundle we have and put the related actions into the document (for some reason the name of the software and its location are not in the Word doc.). The files are named from the software name, ex:Curam GISS CIARA 4.doc, Curam GISS Development 4.doc.....etc.
I also have one Excel Worksheet that has 275 rows, one for each software bundle. Each row has information which was not included when I made the Word Documents.
I'd like to loop through my Excel worksheet and for every matching cell A2 - A275 (Name of software), copy/paste contents from cells A2-A275 and E2-E275 (Name and location of software) into the corresponding Word Document at the top of the document.