Hi,
I have a sheet which is having data in it.
This sheet is locked with a password as it is read only.
I want to provide a search window with a search button on sheet ( called sheet2) or on a separate sheet ( Called sheet10)
Search window will have 4 cells where all 4 or any one can be populated and button pressed . Then corresponding row in sheet2 is highlighted.
OR
If the search window is based at sheet10 ( which is a blank one) then matching row from sheet2 is brought on the screen on sheet10.
( data in 4 search criteria cells take reference search data from columns A ( start date), D ( Asset nomber), H ( fault number) , P ( closed date) of sheet2
Can anyone help me please
Kind regards
Bookmarks