+ Reply to Thread
Results 1 to 2 of 2

Choosing specific cells from lines in different lengths

  1. #1
    Registered User
    Join Date
    12-13-2014
    Location
    Turkey
    MS-Off Ver
    excel 2014
    Posts
    7

    Choosing specific cells from lines in different lengths

    Hi,

    Thanks to Alansidman, who helped to solve my previous question.
    HTML Code: 
    Option Explicit

    Sub LikeNr()
    Dim lr As Long
    lr = Range("A" & Rows.Count).End(xlUp).Row
    Dim lc As Long
    lc = 25
    Dim i As Long
    Dim j As Long

    Application.ScreenUpdating = False
    For i = 1 To lr
    For j = 1 To lc
    If Cells(i, j) Like "19*" Then 'change this value as necessary or add an inputbox to search for a particular value.
    Cells(i, j).Copy Cells(i, 26)
    End If
    Next j
    Next i
    Application.CutCopyMode = False
    Application.ScreenUpdating = True
    MsgBox "complete"

    End Sub


    By above VBA solution I was able to move the cells beginning with specific numbers to a new column.
    Now I have 4 lines (all might be in different lengths), where every 2 of them are identical with first four cells. I want to copy user1 from shorter line to the most right of longer one.

    Above codes are only for moving S1 & T2 to the new columns.
    My second question, how can we add W1 & V2 to the side columns?

    Here I pictured what I tried to explain
    Attachment 364711

    Any help would appreciated.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by atakantekel; 12-13-2014 at 05:39 PM. Reason: forgot to add my second quesiton

  2. #2
    Registered User
    Join Date
    12-13-2014
    Location
    Turkey
    MS-Off Ver
    excel 2014
    Posts
    7

    Re: Choosing specific cells from lines in different lengths

    Is there anybody who'd give an idea about it?

+ 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. [SOLVED] Macro neede to open text files from folder and remove all the lines except specific lines
    By genetist in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-07-2014, 02:44 AM
  2. Choosing specific entries in a range
    By kyleg222 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-27-2012, 12:32 PM
  3. Choosing what lines you want to show in a line graph
    By dandavis1 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-24-2010, 06:05 AM
  4. Choosing specific constrained cells from a separate sheet
    By aslambilal in forum Excel General
    Replies: 2
    Last Post: 07-20-2009, 10:55 AM
  5. Removing Grid Lines on Specific Cells?
    By Xyfy in forum Excel General
    Replies: 4
    Last Post: 09-14-2007, 12:09 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