Hi all,
Novice programmer so please be gentle with me! I'm running Excel 2000, and I want to search for one string in all the worksheets in a spreadsheet (there are about 20). Where do I start?
Thanks in advance..
I am using excel 2003 but will guess the following exists in 2000. At the top go to Edit>Find. Enter the string to search for using "All" or "Any part of text" and under the WITHIN drop down box choose Workbook.