I attach a stripped back example here of what I'm trying to achieve.
You can see the 3 summary tables at the top, where the written item is to be added as a new row. The written assessment is below.
In the full report, there are more tables within the document providing different functions, but I'm not sure how to assign a table an ID as a reference to be able to target it with VBA to be able to add the rows, copy the text etc.
Is there a way to highlight the selected text, and have a button to click to copy it to the red, orange or green table accordingly?
Thanks in advance to anyone who can help advise.
|