create a word doc from excel data

[Bobsa31]

Hi,

I have a large amount of data in an excel spreadsheet, the data can be sorted into discrete systems. I'm not sure if this is possible, however, I need to collate the information in the spreadsheet and create a word doc for each of the systems. I would like to do this by selecting the system from a drop down box and then generating a Word doc based on the information it find, is this possible?

Regards

 

[HackSlash]

I typed the subject of your question in to google and got a really good response from a Microsoft MVP. You should read his advice. I think it will get you down the path:

https://answers.microsoft.com/en-us...document/04a43890-c044-4654-97b9-676610969cbf

 

[Macropod]

I typed the subject of your question in to google and got a really good response from a Microsoft MVP. You should read his advice. I think it will get you down the path:

https://answers.microsoft.com/en-us...document/04a43890-c044-4654-97b9-676610969cbf

Indeed, three Microsoft MVPs (including me) responded. It is undoubtedly possible to transfer data between Excel and Word. As posted, though, the question here is too vague to give a response as to the best approach to the problem. Depending on the requirements, a mailmerge, OLE linking, Word DATABASE field, ADODB datra extraction, or a direct transfer to bookmarks, etc. via VBA code might be suitable.