Is there a quick way to switch data between cells? I.E. Imagine a ranking
system where the data is ever changing. One day I may want to switch the data
from A2 to A5 and A5 to A2. The next may be A7 switching to A1, etc., etc.
Just curious if there is a quick way to do this. I am running excel 2003. Any
and all help is greatly appreciated.