Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-31-2018, 12:02 PM
rsrasc rsrasc is offline Macro Needed to Move Info from Column A to Column B and C Windows 10 Macro Needed to Move Info from Column A to Column B and C Office 2013
Competent Performer
Macro Needed to Move Info from Column A to Column B and C
 
Join Date: Mar 2014
Location: Germany
Posts: 148
rsrasc is on a distinguished road
Default Macro Needed to Move Info from Column A to Column B and C

Hi all,

I have over 500 records in Col A in the following format:

XXX-XX-0065-0 REG-PT
XXX-XX-0119-0 REG-FT
XXX-XX-1106-0 FRS
.
.
.


The numbers after the XXX-XX-????-0, illustrated with ???? varies.


What I need is a macro to move any three of these letters found in Column A to Column C and one row up.

REG-PT


REG-FT
FRS

Also, I would like a macro to move any one of these XXX-XX-????-0 to Column B and one row up.

Hoping there is a solution.

Thank you in advance for your support.

Regards,
rsrasc
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro Needed to Move Info from Column A to Column B and C Move Selection to the next Column on a Page (Not a table) GuitarForLife Word VBA 7 02-09-2018 01:59 PM
MSP 2013 - A new column needed a bit like resource names Peasy Project 5 09-18-2014 01:11 PM
Macro Needed to Move Info from Column A to Column B and C Parsing 'FullName' column - help needed text to column ScottA Excel Programming 3 05-06-2014 12:49 PM
Columns. How to move the left column so it's to the right of the 'right' column ? Vit Word 9 11-21-2012 12:57 PM
Fill column with other columns info Novice Excel Programming 10 07-28-2011 09:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:48 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