| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data swap
is it possible to swap cells without having to cut and paste? if i have data
in b3:b5 and c3:c5, and i want the data in each column to switch, is there a function that allows me to do that? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
data swap
Not without resorting to a macro
Right click the sheet tab, view code and paste this in and run it Sub swap() Range("B3:B5").Copy Range("A65534").PasteSpecial Range("C3:C5").Copy Range("B3").PasteSpecial Range("A65534:A65536").Copy Range("C3").PasteSpecial End Sub Mike "scott" wrote: is it possible to swap cells without having to cut and paste? if i have data in b3:b5 and c3:c5, and i want the data in each column to switch, is there a function that allows me to do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| swap | Excel Worksheet Functions | |||
| I need to swap last name, first name in a cell to first name last | Excel Worksheet Functions | |||
| Swap the X and Y axes | Charts and Charting in Excel | |||
| Swap data from one cell to another | Excel Worksheet Functions | |||
| Is there a quick shortcut to swap the data in two cells? | Excel Discussion (Misc queries) | |||
Hybrid Mode
