Ok, all here is a real challenge for you. (Or maybe not, I am a layman).
Some background first. I am a business manager in Illinois and have 5 teams underneath me. Each team is required to send a daily excel spreadsheet of work completed for their clients to me (lots of random data) and also, from that excel sheet, send a more detailed (i.e. "prettier") version of the data in a word document. I then have to take all of this pieces of information and manually copy and paste the stuff I need into my company's word template. I have tried to get the company to move away from this level of paperwork, to no avail. Now I am seeing if a little programming can go a long way.
I hope that made sense. Ok, so I have written some extremely basic VB code to pull some of the excel data I need, convert it into the format the company likes to see, then send it to word. Therein I copy that data and paste it into my final word template. Thats the most I am able to accomplish at this level of my experience.
I was wondering if there was a way to "auto parse" data from excel and word and "auto fill" it into predetermined sections of my final word template. Basically I am looking for guidance on building macros I can add into both a blank excel and blank .docx file, then once I get my teams reports, copy those files into my "macroed" blank files, and hit run. The macros would search for specific strings of information, pull them out and put them into areas of the final template that they should go.
If this were actually possible I would be extremely grateful. A case of beer would immediately gifted.