Hi,

It's my first time to post here, I hope I'm at the right place.

I want to access data in Excel Sheets via Word. I want to type the name of a steel section in Word and automatically get different information of the choosen section.

I already tried using "vlookup" and "link" to connect Word and Excel which works for one table, but has to be set up again for each new table.
I'm rather looking for a vba solution, but didn't quite find the right way to start.

For summary look at the following picture:
https://imgur.com/a/j9kld