Thanks to all ,
I have a two (2) sheet in a work book Name as (1) Data and (2) search. In data sheet I have huge data whose detail I want to view in search sheet If I type client name or policy no . My search criteria is ok for showing detail only up to 17 row as A1-Q65536 from search sheet, But I also want my result to be view up to last row like A1-IV65536 in search sheet while searching. My concern is that I want my result should contain detail from search sheet that should include entire rows and columns.
Moreover I want the client name or policy number should loop below in (search sheet) as result while I type client name in search sheet in C3.
Like If I type client name like Pramod Kumar and while typing each letter or number of policy should be shown below one by one after I type them in search sheet.
Bookmarks