Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: conditional copying

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Want to copy a row to a new sheet only if the condition in another cell is true.Dont want it to copy the cell if the condtion is false.

  2. #2
    Guest

    Default

    I want to know how to do that too. Although I want to then go to the next item in a list and perform the same function (again only if the condition is met)

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Assuming your data is in column A and your condition to copy is in column B, both on Sheet1, and you wish to copy to Sheet2, then you could try the following..

    Sub copy()
    r = 1
    Do While Cells(r, 1) > ""
    If Cells(r, 2) = "yescopy" Then c$ = Cells(r, 1): rr = rr + 1
    Sheets("Sheet2").Select
    Cells(rr, 1) = c$
    Sheets("Sheet1").Select
    r = r + 1
    Loop
    End Sub

    Note the above will only copy a single cell across to the new sheet. If you need to copy more you should be able to see how by looking at the code, if not reply back and I'll see what I can do

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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