Results 1 to 2 of 2

Thread: Matching values from column C to D and cut pasting to column G

  1. #1

    Matching values from column C to D and cut pasting to column G



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Guys I am new to the forum

    I am new to vba and I am trying to code a bit of automation..
    What I am trying to accomplish is matching the time to the specific code "A207"
    and cutting the value and pasting it to another column..

    here is what I got

    Dim rng As Range
    Dim rngFound As Range
    Dim cellNumber As Integer


    Set rng = Range("C:C")
    Set rngFound = rng.Find("A207")
    cellNumber = 1

    Do While cellNumber < 500
    cellNumber = cellNumber + 1
    If Range("D" & cellNumber) = rngFound Then
    Selection.Cut
    Range("G" & cellNumber).Paste


    Else
    End If






    Thanks,

    M

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,778
    Articles
    0
    Excel Version
    365
    Cross posted and resolved here:
    http://www.mrexcel.com/forum/excel-q...-column-g.html
    Mgmarm, please have a read of http://www.excelguru.ca/content.php?184

Posting Permissions

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