I haven't done VBA in a couple years and have been working on this function for a while now.
If someone can help ASAP, help would be much appreciated.
Basically I have a source list containing 11,000+ numbers.
I have a second call list containing 5,000+ numbers, all of which are in the source list.
The source list contains the numbers + more information such as address, name, etc.
What I want to do is use the call list, and go through each number on that list, look it up in the source list, then copy the entire row from the source list, paste it into a new sheet, and delete the selection from the source list.
The code works, with the exception that it keeps pulling the word "True" instead of the actual value of the call list.
I'm having trouble with it finding the right value, which is why I commented out the bottom portion. It can find and paste just like I want to, so getting it to find the right value is all I need help with right now.
As you can imagine, spending a couple hours trying to figure this macro out will still save me time versus manually finding and copying all 5000 entries. That said, I need this by the morning and have been working on it all night thus far. x.x
edit to clarify, I just need help writing the code that will "ctrl-f" the values in the call list.
Is what I have right now, with number being a value that I "copied" from the call list.
If it matters, I've already formatted the phone numbers in both lists to be text, so I don't think formatting should be an issue, though if it is, please provide assistance as well. (:
Bookmarks