VBA- searching thru multiple wkshts/wrkbks

[Yvannia]

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 this 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, dob, gender etc
I need to make a search dialog whereby the user is allowed to do this:
Search by dob by selecting thru the calendar tool or 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.

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

 

[Yvannia]

VBA- searching thru multiple wkshts/wrkbks
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?

 

[SkipVought]

Hi,

Have you looked at the Edit > Find... feature of Excel?

You can use your macro recorder to gen code once you figure out how to use this feature.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}