View Single Post
 
Old 01-18-2024, 06:46 AM
l0zzie88 l0zzie88 is offline Mac OS X Office 2021
Novice
 
Join Date: Jan 2024
Posts: 2
l0zzie88 is on a distinguished road
Red face Macro/VBA to copy text paragraph and insert as new row in summary table, with RAG

Hello,

I'm trying to set up a Macro which will allow a button to be pressed to copy a selection of text from a report and copy it into a summary table.

There will be 3 tables, which are Red, Amber, Green depending on the report issue raised, so the code needs to be able to select the right table, insert the row, and copy to the relevant text into that row.

Is there a way this can be done, I have tried keywords as triggers, but I'm after a simple way to allow the text to be copy and pasted to the corresponding table. I am on a Mac, so making it extra hard in terms of VBA, Macro's and functions in Word!

Thank you
Lauren
Reply With Quote