cut & paste swapping contents - keyboard shortcut ?

I'm doing a lot of corrections for mixed up information. Is there a function that will cut and paste a cell's contents and automatically push the destination's cells contents to the original cell. Swapping essentially.. if that does exists, I'd assume I could assign a custom keyboard shortcut to the task. Any ideas would be great . thanks !

Hi - this macro should swap the contents of two selected cells
One of the better VBA people can probably come up with a more elegant solution - my way of returning the values of selected cells is clumsy (but it works, I hope)

Please Login or Register  to view this content.

thanks a lot NickyC,

I've worked with formulas in new columns, but where would I add this formula? I couldn't figure it out

... also, I'm attaching a sample/dummy file. The culprits are highlighted in red text

Thanks you guys

Fake sample-Employee List.xls

Hi
it's a macro not a formula, so you will have to copy it into a module in VBA

• press alt+f11 to enter the visual basic area
• select insert>module to create a module to store your macro
• paste the code into the module
• return to the sheet and select developer > macros
• select the macro name and press "run"

if the developer tab is not visible at the top of the sheet, press the office button at the top left and select excel options > popular > and click the "show developer tab in the ribbon" check box

You may also need to change the macro security settings under the developer tab when you return to the sheet to allow the macro to run