Home » Forums » Open Source Learning Center » Question and Answer

Data Swap

Submitted by ulsk on 6 March, 2014 - 06:54

Dear,

Can we swap or exchange data within two cells wchich are together or seperate. For example; I want to send data in C1 to E5 and E5 data to C1. And can we do this for number of sells (blocks).
Hope your usual help
Tks/ulsk

‹ Block cells for updating need help matching cells which contain some of the same information ›
»

There's no "swap" feature

Submitted by chris on 10 March, 2014 - 20:17.

There's no "swap" feature built into Excel - you'll have to move E5 to somewhere else, then move C1 into it, then move your temporary location back into C1. Are you hoping to automate this?

»

Yes sir, I want to

Submitted by ulsk on 13 March, 2014 - 07:58.

Yes sir, I want to automatethis. Otherwise I have to do this every week for the whole sheet.
is there any other way to do this?

»