+ Reply to Thread
Results 1 to 3 of 3

Find Text in Column then Move

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    03-30-2014
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Excel 2013
    Posts
    274

    Find Text in Column then Move

    Hi Appreciate any help here as usual.
    My data gets out of wack and I need to move it back 1 col
    EG: if "1ST" is found in G6 them move G6:AE6 back to F6

    In Column G:G need to find text "1ST"
    then move data in that row including all columns from G:AE
    Back 1 column
    Must do this for each record found in the sheet
    Sheet name is "Ozeform"

    I can do this for the first record found but do not know how to do it for all records found.....

    Range("G2").Select
    Cells.Find(What:="1ST", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
    xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
    , SearchFormat:=False).Activate
    Range("G1").Select
    Cells.Find(What:="1ST", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
    xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
    False, SearchFormat:=False).Activate
    Range(Selection, Selection.End(xlToRight)).Select
    Selection.Cut
    Range("F6").Select
    ActiveSheet.Paste

    Regards
    Graham
    Last edited by Grahamfeeley; 05-28-2014 at 04:33 PM. Reason: want to delete

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Find Text in Column then Move

    Welcome to the forum.

    We'd like to help you but first..

    Pls take some minutes to read forum rules and specially-in this case- rule#3 and add code tags around your code.
    Then anyone will be able to help you.

    **i mooved your thread in VBA section.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Contributor
    Join Date
    03-30-2014
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Excel 2013
    Posts
    274

    Re: Find Text in Column then Move

    This is no longer required
    Thanks all


    Quote Originally Posted by Grahamfeeley View Post
    Hi Appreciate any help here as usual.
    My data gets out of wack and I need to move it back 1 col
    EG: if "1ST" is found in G6 them move G6:AE6 back to F6

    In Column G:G need to find text "1ST"
    then move data in that row including all columns from G:AE
    Back 1 column
    Must do this for each record found in the sheet
    Sheet name is "Ozeform"

    I can do this for the first record found but do not know how to do it for all records found.....

    Range("G2").Select
    Cells.Find(What:="1ST", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
    xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
    , SearchFormat:=False).Activate
    Range("G1").Select
    Cells.Find(What:="1ST", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
    xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
    False, SearchFormat:=False).Activate
    Range(Selection, Selection.End(xlToRight)).Select
    Selection.Cut
    Range("F6").Select
    ActiveSheet.Paste

    Regards
    Graham

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Search rows to find specific text and move to a different column ?
    By Udaipur99 in forum Excel - New Users/Basics
    Replies: 19
    Last Post: 03-19-2014, 01:11 PM
  2. Replies: 12
    Last Post: 01-08-2014, 11:28 AM
  3. Replies: 4
    Last Post: 11-13-2012, 02:16 PM
  4. Need to find text in column U and move it 19 columns to the left
    By ed_the_fed in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 10:05 PM
  5. Find and move text
    By Tellm in forum Excel General
    Replies: 14
    Last Post: 10-10-2011, 01:02 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1