Cut & Paste a Row - Via Dynamically Determined Origin and Destination

  • I'm struggling to find the correct commands and syntax for my simple challenge. I want to:

    1) Search for the word "Reserve" in Column E
    2) Cut the entire row that contains "Reserve" in Column E (Note: This is a header row)
    3) Search for the word "Reserve" in Column K (Note: This will be the first occurence in a range of sorted data.)
    4) Paste/Insert the cut (header) row above the Row that contains the word "Reserve" in Column K (Note: This is the start of the cells in Column K that contain "Reserve")

    This seems like a very straightforward task, yet I'm getting hung up on using the precise language to make this happen.

    Many thanks to you for helping me.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!