Results 1 to 3 of 3

Find Text in Column then Move

Threaded 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

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