In excel, whenever we type a member in Sheet 1, the member should be searched in table or list of members dynamically in Sheet2. If the member is not found in list of members or table, the user should be notified with the error message like “Entered member is not present in the database”.
Could someone provide the steps to get this requirement
Thanks!
srv
Bookmarks