Hello,
Just wondered if someone could help me please, I need to build an excel macro that can open a word template that has bookmarks built in and will either insert Excel answers into the Word bookmark or delete bookmarks when the cell answer equals DELETE, e.g.
Column A (list of bookmarks):
Bookmark1
Bookmark2
Bookmark3
Column B (list of answers):
Name
Address
DELETE
Therefore Name and Address would appear in bookmark1 and 2 but bookmark3 will delete as it is not required.
Any help on this would be great, thank you
Just wondered if someone could help me please, I need to build an excel macro that can open a word template that has bookmarks built in and will either insert Excel answers into the Word bookmark or delete bookmarks when the cell answer equals DELETE, e.g.
Column A (list of bookmarks):
Bookmark1
Bookmark2
Bookmark3
Column B (list of answers):
Name
Address
DELETE
Therefore Name and Address would appear in bookmark1 and 2 but bookmark3 will delete as it is not required.
Any help on this would be great, thank you