Dear all,

I would be very grateful if you could help me with a VBA code for this scenario:

I will select and copy A1 : D300 from Excel to the clipboard and, then, I would like to copy and paste (only!) columns 1 and 4 of this Excel table, i. e. A1 : A300 and D1 : D300, into columns 1 and 4 of a table of the exact same size in WORD with just one click.

After selecting and copying A1 : D300 in Excel, is it then possible (and what would be the VBA code) to have a VBA code in WORD basically doing the following:

1 - Go to Column 1 of the next table (there is only one table in the WORD document) and paste Column 1 of the table in the clipboard, and

2 - Go to Column 4 of the same table and paste Column 4 of the table in the clipboard

The WORD table is of the same size (i. e. 4 columns, 300 rows).

Afterwards, I would like the VBA code to go to each Row of the WORD table and delete all rows which contain a specific wording (let's say "abcd1234").

Thank you very much for your help with this.

Best regards,



Fin