Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 10-09-2017, 11:19 PM
ewso ewso is offline any way to move cells automatically Windows 10 any way to move cells automatically Office 2016
Advanced Beginner
any way to move cells automatically
 
Join Date: Nov 2016
Posts: 80
ewso is on a distinguished road
Default any way to move cells automatically


I have a table with two columns that looks like this..

Jeff...Rita
Lara..Sam
Kirk..Barry


I want to be able to move the names from the second column over to the first column and down one row so that it looks like this..

Jeff
Rita
Lara
Sam
Kirk
Barry

I posted this question in the excel programming forum looking for a macro, but nobody answered me, so I guess nobody knows how to do it with a macro. Is there something I can do?

thanks for help!
  #2  
Old 10-10-2017, 07:12 AM
NoSparks NoSparks is offline any way to move cells automatically Windows 7 64bit any way to move cells automatically Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

Ever wonder if NOT acknowledging peoples assistance until the next time you need them could result in being ignored ?
  #3  
Old 10-10-2017, 09:44 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline any way to move cells automatically Windows 7 64bit any way to move cells automatically Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,919
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Please do not post the same question on different subforums.
You can always bump your post if you do not get an answer within a reasonable period.
Thread closed
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Closed Thread



Similar Threads
Thread Thread Starter Forum Replies Last Post
macro to move cells ewso Excel Programming 1 10-11-2017 12:23 AM
any way to move cells automatically Cells automatically filling in otuatail Excel 3 08-17-2017 11:31 PM
how to move the box automatically when text moves ketanco Publisher 0 04-05-2016 09:00 AM
any way to move cells automatically Linking cells: can sub-cells move with their master-cell when sorting? kw01 Excel 1 06-30-2015 05:02 PM
any way to move cells automatically Automatically add something to cells SavvyEd Excel 2 07-31-2012 08:54 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:50 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft