Consulting

Results 1 to 9 of 9

Thread: Move row if text is in column matches string

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Exclamation Move row if text is in column matches string

    OK i have looked all over and can't seem to find anyone who has had the same issue as i am.

    I would like to create a VBA script that will Search Colum A for 4 employee names out of the list of about 20:
    Julianne
    Ramero
    Allie
    Louis
    This list is dynamic so the row they are in is always changing.

    Then select the corresponding row and cut and paste it to say A36:A40. The original row would also need to be deleted while maintaining the gap between employees.
    I have attached a copy of it with sheets labeled before and after to show what result i am hoping to get! Thanks in advance! Gary
    Attached Files Attached Files

Posting Permissions

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