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.
Bookmarks