Extract Data from specific places in multiple word files to excel

[youbitto]

Hello MrExcel Genuises

I have Multiple word Files that has some data that I need to extract to excel

the documents has over 40 pages and the data I need are in separated pages

I am Asking if there is a way or macro in excel to that work automaticaly

here an example in word :

what i want to be filled in excel

Nouveau Feuille de calcul Microsoft Excel.xlsx
	A	B	C	D
1	Name	Age	Birth	Adresse
2
3
4
Feuil2

Thank you

 

[NdNoviceHlp]

You are welcome again. @hungtbatman1 certainly deserves credit for his/her contributions. Have a nice day. Dave

 

[youbitto]

You are welcome again. @hungtbatman1 certainly deserves credit for his/her contributions. Have a nice day. Dave

@hungbatman1 absolutely deserve my thanks he was very patient with me and the code works very nicely
Ps my name isnt Dave hhhh it is Ayyoub, Dave just a name came to my mind as an example

 

[NdNoviceHlp]

Hi Ayyoub. My name is Dave and it's a good name for example Dave

 

[hungtbatman1]

your code worked perfectly after I added the line
to be honest I dont have the words that I want to extract the informations from but if I remember correctly there is an empty line there
does the code change completly if there is a line or not ?

If there is no empty line, you can't search in string text, as I wrote earlier. Then you have to search in WORD file. I didn't want to write code from scratch to search in WORD, that's why I asked if there is an empty line. But I see that someone already helped you.

 

[youbitto]

If there is no empty line, you can't search in string text, as I wrote earlier. Then you have to search in WORD file. I didn't want to write code from scratch to search in WORD, that's why I asked if there is an empty line. But I see that someone already helped you.

I see. Mr hungtbatman1 thank you very much I appreciate your help and patient