interchange value between any cell by drag and drop

[AKSHAY66]

when I drag Cell value (any number) A1 and drop any cell suppose C4 at that time C4 value (any number) transfer in cell A1 same time just like slider game.

if any solution PPlease send me at akshay66@hotmail.com

thank you

 

[Chihiro]

There may be a way, but not easy I believe. If you can accept solution other than drag and drop there are ways to do it.

1. Use Office Clipboard to to store multiple copy operation and then paste into respective range.


2. Use code in link (modify to suite your need).
https://www.extendoffice.com/documents/excel/860-excel-swap-contents-of-two-cells.html