Results 1 to 8 of 8
  1. #1
    stanlafayette
    Guest

    Moving Rows (2000)

    Attached is a solution that was made to a previous post here, I can't find it now,
    the object is to move an entire row when a cell meets certain criteria, from one sheet in a workbook to another sheet.
    I need to adapt the macro to another worksheet with the selections being Yes, No, NA.
    I made the change to the macro where it has "Approved" to "NO" but it doesn't work. I get no errors.
    The worksheet is attached----"After I played with it"

    Can you help? Thanks

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Moving Rows (2000)

    Is the attachment invisible...'cos I can't see it!
    Could you try sending it again!! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Regards,
    Rudi

  3. #3
    stanlafayette
    Guest

    Re: Moving Rows (2000)

    <P ID="nt"><font size=-1>(No Text)</font>

  4. #4
    stanlafayette
    Guest

    Re: Moving Rows (2000)

    oops

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Moving Rows (2000)

    Did you try approved to "no" (lowercase)?

    Steve

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Moving Rows (2000)

    I'm not sure what you are trying to do. In the macro, cstrSourceSheet is set to "Sheet1", and the macro is looking in column C for the string. However, column C does not contain "approved" or "no". Therefore, the macro never finds anything that needs to be moved. Column C contains only "pending" or "not approved". What do you want to move?
    Legare Coleman

  7. #7
    stanlafayette
    Guest

    Re: Moving Rows (2000)

    If column "C" contains "No"
    I want the entire row to move to sheet 2.
    Sheet 2 would contain a list of all entries on sheet one that have "No" entered in C column

  8. #8
    stanlafayette
    Guest

    Re: Moving Rows (2000)

    The lower case "no" worked fine thank you so much

Posting Permissions

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