+ Reply to Thread
Results 1 to 3 of 3

Macro to Move row append to new worksheet with user input messagebox

  1. #1
    Registered User
    Join Date
    05-21-2015
    Location
    Carrollton, Ga
    MS-Off Ver
    Office 2013
    Posts
    4

    Macro to Move row append to new worksheet with user input messagebox

    Greetings everyone,

    Had a long winded post, however clicked the wrong button and lost it all.
    The attached Template.xls is one of several hundred we have here to plow through.
    (Names and places have been changed to protect the innocent.)

    1. Key_Word_Search_Yes_No_Cancel
    2. KeyWordSearch
    3. Search_Move_Row

    Three macros are included. 1st one I broke... I admit this. So many attempts to make this thing work.
    2nd and 3rd Macro's are based off code from Tom Urtis with modifications of course. (excellent code btw)
    These are nice due to end report showing how many where located and displayed to the user.

    These find the correct entries but overwrite each other instead of appending.
    (coding some of the common searches would be nice rather than plucking at the keyboard over and over for the same search criteria.)

    Ideally since each workbook can have 3 or 20+ worksheets. It would speed up the process if the macro Searched the entire workbook.
    Appending to "Contents" worksheet found in each excel file under "Drawing Binder". Deleting the original row source and leaving no blank rows.
    Be happy to just shove it all under sheet2 if this simplifies the process.

    Under the template.xls sheet2 shows yellow highlighted items that are picked up but not needed. (not sure how to exclude this from the search)
    The common search criteria inputs are:
    ROLL - 8"
    ROLL-8"
    MM FACE
    8" ROLL
    12" ROLL
    304.8MM

    Note: there are others but not as common. Hence the need to search these automatically then loop to ask for any other inputs from the user.
    Macro's 2 and 3 work but only for one search, one worksheet at a time. This would take a long time to complete.
    Looking forward to any help and guidance.

    And yes.. final output sorted by column C
    Column "B" is hidden but needs to go along for the ride over to "Contents" or "Sheet2" whichever helps simplify the process.
    Klaatu Barada Nikto

  2. #2
    Registered User
    Join Date
    05-21-2015
    Location
    Carrollton, Ga
    MS-Off Ver
    Office 2013
    Posts
    4

    Re: Macro to Move row append to new worksheet with user input messagebox

    More description or details needed perhaps?
    Sorting can be done manually after all the searches are completed.
    These Excel workbooks go back a few years, however all have the same basic layout.
    Will be working with these macros this week and next. Any day now the tap on the shoulder will come to start this tedious task.

  3. #3
    Registered User
    Join Date
    05-21-2015
    Location
    Carrollton, Ga
    MS-Off Ver
    Office 2013
    Posts
    4

    Re: Macro to Move row append to new worksheet with user input messagebox

    Let me try a different tact...
    Basically this macro works but so far not able to get this to append when activating this line:
    'Set wsDest = ActiveWorkbook.Worksheets("Sheet2")
    While deactivating this line:
    Set wsDest = ActiveWorkbook.Worksheets.Add
    Currently the macro adds a new worksheet each time the macro is run and valid search criteria is input.
    It also will only search within the active worksheet. To avoid running through "Many" spreadsheets per workbook.
    Would be great if it search the entire workbook. doable?



    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 11-10-2014, 11:49 PM
  2. [SOLVED] only display a messagebox when the sheet is activated through user, not macro
    By emilyloz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-21-2013, 08:15 AM
  3. Macro to move data from an input form to a datalog worksheet
    By wstring in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-02-2013, 12:28 PM
  4. Replies: 3
    Last Post: 03-25-2006, 12:25 PM
  5. How to trigger a macro on a worksheet on the event of user-input?
    By fiven in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-20-2005, 11:38 PM

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