Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Swap data from one cell to another
Is there a way to swap data from one cell to another?
What I need is a way to swap the data from say E12 to F12 and also swap F12 to E12 at the same time. Don't know if this is possible, but any help wold be appreciated. -- Brooks W. |
#2
|
|||
|
|||
You can do it with a macro:
Sub SwapData(rng1 As Range, rng2 As Range) Dim sTemp As Variant sTemp = rng1 rng1 = rng2 rng2 = sTemp End Sub Put this in a standard module. Then: SwapData Range("E12"), Range("F12") typed and entered into the Immediate Window will swap the data. -- Vasant "Brooks W." wrote in message ... Is there a way to swap data from one cell to another? What I need is a way to swap the data from say E12 to F12 and also swap F12 to E12 at the same time. Don't know if this is possible, but any help wold be appreciated. -- Brooks W. |
#3
|
|||
|
|||
What you want can be accomplished if you EditCut the text in F12, select
E12, and InsertCut cells "Brooks W." wrote: Is there a way to swap data from one cell to another? What I need is a way to swap the data from say E12 to F12 and also swap F12 to E12 at the same time. Don't know if this is possible, but any help wold be appreciated. -- Brooks W. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
Import Data into same cell | Excel Discussion (Misc queries) | |||
I want a window to cell data that conains links to PDF files and . | Excel Discussion (Misc queries) | |||
Repeat Cell Data | Excel Worksheet Functions |