Forum Discussion
switch data between cells
Is there an easy way to swap data between two cells (or two ranges of cells)? I'm always doing it the long way: copy/paste somewhere else, then copy/paste again.
For example, I want to put the contents of cells F2:F4 into E1:E3 and put the contents of cell E1:E3 into F2:F4.
If it makes any difference, these are usually text cells with no formulas.
1 Reply
- Hello,
This is possible with Excel VBA. The link below perfectly answer your question. Do check it out and follow the logic
https://www.excel-easy.com/vba/examples/swap-values.html
