Hi
I have two sheets, existing clients & pc clients. In my userform, i want to be able to enter a client name, press search and excel must search in both sheets for the client name and display all the data from that row in the userform.
also....
I want to be able to enter a suburb and by selection of the option buttons, excel must search for the suburb either in the existing clients sheet, the pc clients sheet or both and display all of the rows that have that suburb in the userform.
Attached is the workbook that i am reffering to. I have no clue where to even begin with the code for this. please help.
Bookmarks