+ Reply to Thread
Results 1 to 2 of 2

Seach, Copy, select paste location, paste using macros

  1. #1
    Registered User
    Join Date
    12-16-2010
    Location
    North Carolina, United States
    MS-Off Ver
    Excel 2007
    Posts
    1

    Post Seach, Copy, select paste location, paste using macros

    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.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: Seach, Copy, select paste location, paste using macros

    To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

    Doing this will ensure you get the result you need!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1