VBA- searching thru multiple wksheets/wkbook

[ACOM]

Hi, I have been tasked to come up with a user friendly vba dialog in ms excel. I am not very familiar with programming and any help rendered will be greatly appreciated.

I need to do the following:I have multiple worksheets/ workbooks that hold user info such as address, country, first name,last name, ID,dob, gender, occupation etc
I need to make a search dialog whereby the user is allowed to do this:
1-Search by ID by selecting thru the calendar tool OR
2- search by first and last name. When he clicks search, I need the particular worksheet holding the data to pop up and show the user the data that was requested for.All data in ID column is unique...but for first n last name, i have a few people who have identical names

Is this possible and if so how do I go abt it?

[mhuston]

If each worksheet is named for the user, this will allow selection of a worksheet from a listbox:

Please Login or Register  to view this content.

I do not understand the connection between selecting a date from a calendar and an ID.

[ACOM]

Hi and thank u so much for ur input i greatly appreciate it!
the following codes did it for me

Please Login or Register  to view this content.