Employee Phone Contacts List.xlsm
Attached is the file I am working on.
I have a code half written and it performs quite well (so far). My language is correct to search the entire workbook - every cell in every sheet. For some reason when I enter the search parameters for a cell not in column A it returns not found. Why? Also, when returned a not found message, it returns a message for every sheet. I have to click OK once for every sheet.
I am also at a loss as to how to write the code for various types of phone numbers. This list will be used by more than just myself and I have no control over how others may enter information. Phone numbers can be listed in may ways. What does the code need to say to allow for the periods, dashes, spaces, no spaces, etc?
Any help will be appreciated. Thanks in advance!
Bookmarks