Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 16th 05, 02:55 PM
Brooks W.
 
Posts: n/a
Default 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   Report Post  
Old May 16th 05, 03:48 PM
Vasant Nanavati
 
Posts: n/a
Default

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   Report Post  
Old May 16th 05, 03:50 PM
Duke Carey
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
up to 7 functions? ALex Excel Worksheet Functions 10 April 12th 05 06:42 PM
Import Data into same cell ib_redbeard Excel Discussion (Misc queries) 3 March 1st 05 12:08 PM
I want a window to cell data that conains links to PDF files and . WEATHER TECH. NOT A ROCKET ENGINEER Excel Discussion (Misc queries) 1 February 24th 05 08:21 PM
Repeat Cell Data Pinky Excel Worksheet Functions 1 January 18th 05 05:38 PM


All times are GMT +1. The time now is 12:32 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017