Filtering by list of keywords and pasting results into spreadsheet

Hello, it works, but the problem is that I need the partial name in the cell next to the full employee name, in the output. this way I can tell which phrase each full employee name is associated to. Basically when I run the macros it places the full employee names under the partial name in Sheet 1. I would like instead to shift the full employee name to the right by one cell. And in that cell it was initially in have the partial employee name that is associated to.

you might see what I mean in sheet 3 of the attached spreadsheet i posted above. thank you very much so far for the help

Thanks! That works great.

I have one more question.
I would like to speed the process up, I was wondering if rather than going into Sheet 2 and getting each employee row associated to the partial employee name one by one. If it would be possible to filter Sheet 2 by the partial employee name, and cut and paste all those in one swoop into Sheet 1. The output would be the same as the macros you supplied above. I just believe it would speed things up significantly since there are about 600,000 records in Sheet 2 and 3000 partial names in Sheet 1.

Thanks shg for your help

Sorry, do you think you can provide me with an altered code that can do that?

Sorry again to bother shg, its the filtering, and then cutting and pasting that I was referring to.

Hello, So basically Im working with the macros you posted at 8:26 pm on 8/21 because that works great, the last one posted I encountered problems with, which is fine I can stick with the older one.

I have a question regarding the older macros because when I run it, my memory usage on task manager is at 300,000K for excel and then once I start the macros it increases every second by 1k until it reaches 1,700,000K and then the excel program freezes and it says it is out of memory even though I have 2gb of ram in my computer. Im not sure why the memory usage for this macros increases, shouldnt it remain constant because the same task is being repeated?

Also that macros works correctly, although slow, the output is correct, so I will use it. However, I dont want to keep restarting excel due to the memory usage error. I would like to just run the macros overnight and see the output in the morning. Thanks

I also encounter this random error sometimes where it just copies and pastes the same name over and over again in the output. It happens at random points while running the Macros. If i rerun the Macros this happens again but at different points. Its a strange problem

Actually I figured out the problem on my own but I need to make a minor edit to the code for the macros posted at 8:26pm on 8/21 by shg.

Basically, I need the workbook saved after it looks up 20 or so employee names.
This resets the memory usage.

All I need help with is incorporating in the code posted on 8:26pm on 8/21 by shg a way to save the workbook after it looks up 20 employee name keywords.

Thank you

Sorry for posting so much, Please ignore my previous 2 posts. I figured out another workaround, and I believe its a quick edit to this code, I just have no idea how to do it. The problem with my computer is after maybe 10 or 20 minutes of running the macros it freezes up. Then I have to copy whatever output that was completed at the bottom of sheet 1 into another sheet so that I can restart the Macros again. Otherwise it will start looking up values from the bottom of the sheet again and going up, when some of the values were already looked up. Basically I just want this Macros to resume from the place it stopped at when I press run macros the second or third time. So right above the last line of output it procured from sheet 2.

This is the macros I am using which shg created, you can use it with the excel worksheet posted in my third post.

I really would appreciate help, because after this gets figured out Im done with this project, and I believe it shouldnt a complicated edit to the below macros.

Kind Regards.

Please Login or Register  to view this content.