Results 1 to 9 of 9

Excel 2007 : Moving a Range Based on Variable Text Value

Threaded View

  1. #1
    Registered User
    Join Date
    06-11-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    46

    Moving a Range Based on Variable Text Value

    Hello,

    I am trying to laterally move User IDs from Column A Column R.

    Daily, the Users change (User ID: 7000, User ID: 7800), however they always start with the phrase "User ID: ".

    The row location of the User IDs also change, but they are always in Column A.

    Here is the code I tried. When I run it, it does absolutely nothing:

    Sub MoveOver()
      For Each Cell In Range("A:A")
        If Cell.Value = ("User ID*") Then Cell.Offset(0, 17) = Cell
        Next
    End Sub
    Any help would be appreciated. Thank you, in advance.
    Last edited by KSSLR; 06-12-2012 at 01:03 PM.

Thread Information

Users Browsing this Thread

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

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