K
KEA
I am trying to design a form in Excel to retrieve all occurances of data
associated with names.
I want to be able to type the name of an employee in one cell, and then have
that used as a search in the Excel database to locate all occurances of that
employees names, and the row data that is associated with each occurance.
For instance:
If I enter "John Smith" as my search criteria, and there are five entries in
the database associated with John Smith, I would like all data associated to
be retrieved and displayed on the worksheet so that column data can be
displayed.
This is what I am hoping the output will look like:
A B C D
1 John Smith 609-039005 6969 First St. 354
2 John Smith 609-039006 6969 First St. 210
3 John Smith 613-123123 6969 First St. 125
4 John Smith 605-045876 6969 First St. 867
5 Total: 1556
Any help would be appreciated.
associated with names.
I want to be able to type the name of an employee in one cell, and then have
that used as a search in the Excel database to locate all occurances of that
employees names, and the row data that is associated with each occurance.
For instance:
If I enter "John Smith" as my search criteria, and there are five entries in
the database associated with John Smith, I would like all data associated to
be retrieved and displayed on the worksheet so that column data can be
displayed.
This is what I am hoping the output will look like:
A B C D
1 John Smith 609-039005 6969 First St. 354
2 John Smith 609-039006 6969 First St. 210
3 John Smith 613-123123 6969 First St. 125
4 John Smith 605-045876 6969 First St. 867
5 Total: 1556
Any help would be appreciated.