kamitz
05-17-2010, 03:54 AM
Hi,
I am trying to create a search form to allow the user to search for a particular scholar. Currently, I have segregated the data into 5 sheets (namely Scholar, Contact, Scholarship & Bond, Bank, School & Grades)
What I attempt to do is to incorporate Excel's Custom Autofilter. The only difference is me creating another combo box to allow the user to filter by the respective fields in the 5 worksheets.
Problem is, I can't seem to integrate all the data (in the 5 worksheets) to allow the user to search.
Please advice. Your assistance is greatly appreciated. Thanks in advance!
I am trying to create a search form to allow the user to search for a particular scholar. Currently, I have segregated the data into 5 sheets (namely Scholar, Contact, Scholarship & Bond, Bank, School & Grades)
What I attempt to do is to incorporate Excel's Custom Autofilter. The only difference is me creating another combo box to allow the user to filter by the respective fields in the 5 worksheets.
Problem is, I can't seem to integrate all the data (in the 5 worksheets) to allow the user to search.
Please advice. Your assistance is greatly appreciated. Thanks in advance!