Macro Help Between Microsoft Word And Microsoft Excel ON Apple Mac!

[Harvey12]

HI Guys!

Looking for some more macro help if possible! I have word documents each page containing various information about each of our different guests, I have an Excel sheet containing a host of information and I was hoping to move the information in word into excel.

So in a nutshell the excel doc contains name, email, date stayed & comments I need a macro that takes the name of the person staying inserts a row in the excel sheet where their date stayed is (currently the date stayed is in the format dd/m/yyyy and populated in one long list) and inputs that new data there so for example I have supplied some false data below:

[TABLE="width: 829"]
<tbody>[TR]
[TD]Mr Jon Smith[/TD]
[TD]25/08/2017[/TD]
[TD]********@hotmail.com[/TD]
[/TR]
[TR]
[TD]Mrs Joanne Hunter[/TD]
[TD]25/08/2017[/TD]
[TD]*****@gmail.com[/TD]
[/TR]
[TR]
[TD]Mrs Julie Tompson[/TD]
[TD]25/08/2017[/TD]
[TD]********@yahoo.co.uk[/TD]
[/TR]
</tbody>[/TABLE]

This is what the excel sheet looks like, I can supply a word document to anyone who can help! I hope this makes sense

Thanks,
Harvey