| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving cells
All data is kept in a single column, the number of rows varies (up to 2ooo)
How to move the cells in col. A:A next to the higher cell in Col. B:B? Example: A2 goes to B1 (row 2 thereby is empty now) A4 goes to B3 (row 4 thereby is empty now) A6 goes to B5 (row 6 thereby is empty now) etc. I´m sure there is a better way than record a macro that does it one by one. (And where to stop?) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving text around cells without moving boarder lines | Excel Discussion (Misc queries) | |||
| Enter Key + Dragging Cells / Moving Cells | Excel Discussion (Misc queries) | |||
| Arrow Keys Moving Window Frame instead of Moving Between Cells | Excel Discussion (Misc queries) | |||
| moving cells | New Users to Excel | |||
| Cells(col,row) keep moving to lower case and I can not ref. a cells in a differnet sheet | Excel Programming | |||
Threaded Mode
