Hi All,
I am new to writing this Macro stuff but have been successful with a couple tricky ones so far, so any help would be much appreciated.
I have the task of putting property availability schedules together for clients. This task is quite laborious as I have to copy the information from previous schedules into the format in the Word Document that we send out to the clients. I have to do this every time the property meets a clients requirement. The Table in Word has six columns with the following headings:
Address
Gross Frontage
Ground Floor
Other Floors
Tenure
Comments
It would make my life much easier if I could create a central excel database to store all the different details for each property that we get sent. So that I can then use a macro to copy the active cells to the word document. E.g. If there are three relevant properties then I could highlight the three rows of information and it would extract this information into the Word Document under the relevant headers in the table.
Not sure if this is entirely clear but if anyone has any answers then that would be greatly appreciated.
So far I have written a code that will open up the subject word document but not sure how to copy the specified cells into the designated word template.
Thanks
Seb
I am new to writing this Macro stuff but have been successful with a couple tricky ones so far, so any help would be much appreciated.
I have the task of putting property availability schedules together for clients. This task is quite laborious as I have to copy the information from previous schedules into the format in the Word Document that we send out to the clients. I have to do this every time the property meets a clients requirement. The Table in Word has six columns with the following headings:
Address
Gross Frontage
Ground Floor
Other Floors
Tenure
Comments
It would make my life much easier if I could create a central excel database to store all the different details for each property that we get sent. So that I can then use a macro to copy the active cells to the word document. E.g. If there are three relevant properties then I could highlight the three rows of information and it would extract this information into the Word Document under the relevant headers in the table.
Not sure if this is entirely clear but if anyone has any answers then that would be greatly appreciated.
So far I have written a code that will open up the subject word document but not sure how to copy the specified cells into the designated word template.
Thanks
Seb
