Excel 2003 value search multiple worksheets

April 7, 2011 at 07:56:57
Specs: Windows XP
Hi... In Excel 2003 - how do I perform a search for a value on all worksheets in a workbook without going to each sheet individually and performing a search? For example, I want to be able to search for a person's last name and it could be on any of the 10 or so sheets in the workbook. Each sheet is laid out identically, only the data is different. And there's a column of last names on each sheet. Your help is most appreciated!

See More: Excel 2003 value search multiple worksheets

Report •

April 7, 2011 at 10:55:58
In the Search dialog, click Options and select search in workbook.

Report •
Related Solutions

Ask Question