Hi guys,



(Sorry no native speaker here)
I have got a large Excel-sheet and I always get 2 different word templates filled with data (depending on what amount of data is filled in the data mask, the resulting word-table has a different amount of rows and columns).
For example: If someone filled in the field "Age" with 30, then in word it appers a row named Age: 30.
Unfortunately, some of the fields are merged .

For now I copy every single word table into excel and find the data via vlookup/index&match. After finishing one row I have to copy it and paste only the data without formulas and then I can continue and copy paste the next 2 word tables and so on...
Since I am getting about 50-100 word tables every day I am looking for a more comfortable way to fill the data.

Can I wirte some kind of macro that automatically finds the key words (like "Age") and imports the belonging data (like "30") into the wanted column in excel? Without me having to copy&paste every single word table and then replace the formula with text before copy&paste the next word table?

I am really sorry but all of these data is hyper sensitive so I cant show you what I mean