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
Hi VSR,
Use the Worksheet_Change event in Sheet 1 to Launch the Finder for Sheet 2.
Then, if Finder was unsuccessful, generate message box with notification.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thanks for your valuable inputs. As I am new to this Macro environment, Could you please provide in details steps to implement my requirement.
Hi and welcome to the forum
This could also be done with a simple vlookup(), wrapped in an IF() statement to return the “Entered member is not present in the database” message if not found.
Another option would be to use data validation on that cell (based on the names list) to only allow existing names to be entered
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks for your inputs!
Requesting you please provide clear steps to implement my requirement.
Thanks!!
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Hi,
Please find my requirement in below wit images.
Excel File Name: Book1
Two Sheets: Sheet1 & Sheet2
1. In Sheet2, We are having data of whole sheet2(Here I am showing with sample )
11.jpg
2. In Sheet1, There is Text option, In That We have to enter our Text(Here DOG)
That Entered text have to search in Sheet2 and If Text is not existing Then it should be pop up with message as "Member existed in Database"
22.JPG
3. In Sheet1, There is Text option, In That We have to enter our Text(Here GOLD)
That Entered text have to search in Sheet2 and if text not existing in sheet2, Then it should be pop up with message as "Entered member is not present in the database"
33.jpg
Kindly check my screenshots and provide the clear steps to proceed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks