You can search the whole workbook, select all sheets using click first, hold
down shift and click last sheet, then do the search
later don't forget to ungroup them or all changes made in one cell will be
done in all sheets

Regards,

Peo Sjoblom


"Kitty" wrote in message
...
I'm trying to search a large workbook for specific work order numbers, can
I
do this or do I have to search each individual sheet?