| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
move values from top of column B to bottom of column A
I want to find the next not empty cell in column B.
Cut the cell value. Find the next not empty cell in column A. Paste the cell value. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
move values from top of column B to bottom of column A
On Wednesday, 23 January 2019 04:22:55 UTC+13, wrote:
I want to find the next not empty cell in column B. Cut the cell value. Find the next not empty cell in column A. Paste the cell value. I hope there aren't thousands of numbers. One way would be to select all the empty cells in column B use the "delete cells" with the "shift cells up" option after that you could select the cells, cut them and paste them to the list in column A regards Bill K |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting one column, move some duplicates to bottom of sort | Excel Programming | |||
| match values in column against another column and move | Excel Programming | |||
| How to Move from bottom of one column to top of next | Excel Discussion (Misc queries) | |||
| Move to bottom of Column | Excel Programming | |||
| Shortcut to move to bottom (last) cell in a column | Excel Discussion (Misc queries) | |||
Linear Mode
