Quickly move data from one spreadsheet to another.
In this topic we give a short description for a features which you can use to merge data.
Clipboard:
Select the range you need on any sheet. Press Ctrl+C or Ctrl+X (or use Copy or Cut commands from the Right Click Menu) to place data to clipboard. Then select destination range and press Ctrl+V (or use Paste command from Right Click Menu).
Drag'n'Drop:
Select the range you need on any sheet. Drag it with a mouse to any sheet, place it over any range and drop. Data is pasted into destination range. If you move data inside one worksheet - WCT moves dragged range to new position. To create a copy of the source range you should hold Control key when dropping data.
Clear selected range:
Select the range you need on any sheet. Press Delete button or use Delete command from the right click menu.
Quick Merge Toolbar:
This set of commands quickly moves data from one worksheet to another or deletes data from the sheet. Read more about this toolbar in the Quick Merge Toolbar topic.
If you use the operations described above, WCT does not update list with differences and differences marked on the sheets as changed. Please, repeat comparison if you need to refresh list with differences after your changes.