Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 22nd 19, 03:22 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 18
Default 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   Report Post  
Old May 29th 19, 06:24 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: May 2012
Posts: 7
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sorting one column, move some duplicates to bottom of sort Greg Excel Programming 17 November 2nd 09 01:37 PM
match values in column against another column and move Sean Excel Programming 0 June 5th 08 08:27 PM
How to Move from bottom of one column to top of next Bonnie Excel Discussion (Misc queries) 1 December 21st 06 05:18 PM
Move to bottom of Column Nigel Excel Programming 6 December 22nd 05 06:33 PM
Shortcut to move to bottom (last) cell in a column Frustrated Excel Discussion (Misc queries) 1 September 21st 05 03:47 AM


All times are GMT +1. The time now is 11:32 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017