Hello everybody. I need to find a way to swap values between cells by the use of shortcut keys. Attached please find a sample sheet. Here you can see that in column A, B and I there is data (data is always in 4 cells columns format). is it possible to create some sort of code to help swap values (if the destination cells have values in them, these values will have to go automatically into the cells where I selected the first data). if destinations cells have no data, the selected data can be input in the destination cells and the origin cells can be emptied again. Data swap can happen anywhere in the sheet.



Thank you all for any input

Attached Files

Test.xlsm (8.3 KB, 8 views)