There should be a swap function for 2 values

[Guest]

How often does it happen within a table that you need to copy a value to a
cell, but there is already data inside it. So you need to copy the end field
to a third cell, then put the original value to the cleared cell and then
copy removed data somewhere else.

A great function would be SWAP - where you can simply swap the values
between 2 cells. that would save several steps and would give Excel a lead in
functionality and comfort.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...1-11e4ddcaa3e2&dg=microsoft.public.excel.misc

 

[jetted]

Hi

I would try the option named scenario under the menu tool.

see attach document.


+-------------------------------------------------------------------+
|Filename: scenario.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4998 |
+-------------------------------------------------------------------+