I'm trying to find a quick way to swap a selection of data in one row of a table (not necessarily the whole row) with a selection of data in another row. The selections are the same size, ie.
Select data in row 6, columns 6-10 inclusive
Move to row 8, columns 6-10 inclusive
and
Select data in row 8, columns 6-10 inclusive
Move to row 6, columns 6-10 inclusive
At the moment I'm taking from one row and overwriting another, and then having to type data into the first row manually. This takes a very long time when you have to do it 20-30 times throughout a document. There must be a way to make two selections, run a macro and have the two swapped over in an instant.
I hope I've explained my problem clearly enough. Any thoughts welcome as this could save me a lot of time.
Select data in row 6, columns 6-10 inclusive
Move to row 8, columns 6-10 inclusive
and
Select data in row 8, columns 6-10 inclusive
Move to row 6, columns 6-10 inclusive
At the moment I'm taking from one row and overwriting another, and then having to type data into the first row manually. This takes a very long time when you have to do it 20-30 times throughout a document. There must be a way to make two selections, run a macro and have the two swapped over in an instant.
I hope I've explained my problem clearly enough. Any thoughts welcome as this could save me a lot of time.