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:
<tbody>
</tbody>
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
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:
Mr Jon Smith | 25/08/2017 | ********@hotmail.com |
Mrs Joanne Hunter | 25/08/2017 | *****@gmail.com |
Mrs Julie Tompson | 25/08/2017 | ********@yahoo.co.uk |
<tbody>
</tbody>
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
Last edited: