Ask Mac Questions and Get Answers from Experts ASAP
Re your statement:
"...Putting them in a combined file and using Remove Duplicates. I'm hoping there is a FIND feature of some kind that will extract the rows that have matching phone numbers..."
I can help with that part if you can send me the combined file
Yes I will show how once I review the data and understand the requirement. So please go ahead and send me the Excel file that has the two sheets (i.e,. lists)
You can use the paperclip tool on your reply toolbar
You can also go to http://www.wikisend.com/ and upload the file there (no need to signup) then copy the "File ID" number (or the download link) that you will be given and paste it here in your reply.
If the file has sensitive information let me know before you upload it
No it is not secure. You need to replace the names with dummy values
This thread is getting very extended and we don't get compensated unless we give an answer
Here is the file with the extracted data
Hope this is ok. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution
For further assistance make sure to open a new ticket
Ok here is the test file with the macro which is run by clicking the Go! button (make sure that your Excel options is set to allow macros to run, otherwise nothing happens when you click the Go! button)
Try changing some phone numbers to see how it works
If the results are correct you can authorize payment so we can continue