Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page move cells automatically
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 10-10-2017, 11:42 PM
ewso ewso is offline move cells automatically Windows 10 move cells automatically Office 2016
Advanced Beginner
move cells automatically 		 
Join Date: Nov 2016
Posts: 80
ewso is on a distinguished road
Default move cells automatically
Moderator..Please delete my post in the excel programming forum. Nobody knows how to do this with a macro over there so maybe I can get a way in this forum to do it without a macro. Thanks.

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


thanks for help!
Reply With Quote
  #2  
Old 10-11-2017, 12:27 AM
macropod's Avatar
macropod macropod is offline move cells automatically Windows 7 64bit move cells automatically Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
You can't move content with a formula; you can only replicate it.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-11-2017, 01:06 AM
ewso ewso is offline move cells automatically Windows 10 move cells automatically Office 2016
Advanced Beginner
move cells automatically 		 
Join Date: Nov 2016
Posts: 80
ewso is on a distinguished road
Default
so would there be a way to do what I'm asking by replicating the cells?
Reply With Quote
  #4  
Old 10-11-2017, 06:25 AM
ArviLaanemets ArviLaanemets is offline move cells automatically Windows 8 move cells automatically Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default
1. You design a sheet with formulas to get wanted result;
2. You copy the range with formulas, and paste it to new (or same) location using PasteSpecial.Values option.
Reply With Quote
  #5  
Old 10-11-2017, 07:43 AM
xor xor is offline move cells automatically Windows 10 move cells automatically Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Maybe like the attached.
Attached Files
File Type: xlsx TwoColumnsToOne.xlsx (9.0 KB, 12 views)
Reply With Quote
  #6  
Old 10-12-2017, 12:41 AM
ewso ewso is offline move cells automatically Windows 10 move cells automatically Office 2016
Advanced Beginner
move cells automatically 		 
Join Date: Nov 2016
Posts: 80
ewso is on a distinguished road
Default
Quote:
Originally Posted by xor View Post
Maybe like the attached.
xor..I opened the spreadsheet but I don't see a formula. what do I do with it?
Reply With Quote
  #7  
Old 10-12-2017, 01:09 AM
xor xor is offline move cells automatically Windows 10 move cells automatically Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
There are formulas in A12:A17.
Reply With Quote
  #8  
Old 10-12-2017, 03:27 AM
ewso ewso is offline move cells automatically Windows 10 move cells automatically Office 2016
Advanced Beginner
move cells automatically 		 
Join Date: Nov 2016
Posts: 80
ewso is on a distinguished road
Default
okay I see the formula now. Can you tell me how I would adapt that to much bigger spreadsheets and with the names in different columns or rows?
Reply With Quote
  #9  
Old 10-12-2017, 03:36 AM
xor xor is offline move cells automatically Windows 10 move cells automatically Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
It would be much easier if you could upload a file with a reasonable set of sample data.
Reply With Quote
Reply

« Previous Thread | Next 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 ewso Excel 2 10-10-2017 09:44 AM
how to move the box automatically when text moves ketanco Publisher 0 04-05-2016 09:00 AM
move cells automatically Linking cells: can sub-cells move with their master-cell when sorting? kw01 Excel 1 06-30-2015 05:02 PM
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 04:31 PM.

Contact Us - Privacy Statement - Top

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