I am a novice user that can do basic macro recording and modifications of macros to streamline simple macros. I have a more complex need and don't know how to accomplish the following tasks using excel macros is 2007 excel.

Let's see if I can clearly explain what I want to do.

1. I want to enter a value and search for the value in column H.
2. Once the value is found I want to select the row where the value is found along with 1 row above and 5 rows below the selected row.
3. Once selected, I want to copy the selected rows.
4. I want to then select a cell in column H where I want the copied information to be inserted and then I want to insert the copied rows 2 rows above the selected cell.

To complicate this more, the worksheet must remain protected after the search, copy, and paste function is complete. Ideally, I would like to have all these steps happen with one macro and 2 user inputs, but if it is not possible, then there could be 1 copy macro and 1 paste macro.

Thanks in advance to anyone that can help.