dupledge
07-07-2006, 06:17 PM
I have a series of worksheets with the following format
Fisrtname,Surname,Landline, cellphone, email
John Doe 1234567890 1234567890 jdoe@somewhere.com
I need to creat a search form that lets a user enter firstname or surname or both and it return just the firstname/surname/landline/cellphone in the matching row (or rows if duplicated). If a user enters just the firstname or just the surname it should return firstname/surname/landline/cellphone in the matching row/s Can this be done. I currently have it searching ranges but can only get it to return on one search criteria (eg surname only)
Fisrtname,Surname,Landline, cellphone, email
John Doe 1234567890 1234567890 jdoe@somewhere.com
I need to creat a search form that lets a user enter firstname or surname or both and it return just the firstname/surname/landline/cellphone in the matching row (or rows if duplicated). If a user enters just the firstname or just the surname it should return firstname/surname/landline/cellphone in the matching row/s Can this be done. I currently have it searching ranges but can only get it to return on one search criteria (eg surname only)