I have a work book in Excel 2007 with a sheet for each month jan-dec plus a summary sheet that totals the incidents opened and closed each month and does a nice little picture for the management.
Each months sheet contains details of specific actions or incidents that took place that month.
Each action or incident has a unique identifier.
I want to be able to add a search box to the summary sheet that will replicate the Find funtion without having to click Find & Select, select Find then tick the search entire workbook option each time.
I want the user to enter the unique ID, hit enter or click a button and have it jump to the cell in the workbook with the matching value.
Any ideas?
Each months sheet contains details of specific actions or incidents that took place that month.
Each action or incident has a unique identifier.
I want to be able to add a search box to the summary sheet that will replicate the Find funtion without having to click Find & Select, select Find then tick the search entire workbook option each time.
I want the user to enter the unique ID, hit enter or click a button and have it jump to the cell in the workbook with the matching value.
Any ideas?
Comment