how do I search workbook for data
 

I have separate worksheets for each month and would like to search the whole
workbook for specific data.

how do I search workbook for data
 

Select all sheets first.

Suze wrote:

I have separate worksheets for each month and would like to search the whole
workbook for specific data.

how do I search workbook for data
 

Hi,
choose the first tab, then press shift and choose the last tab, so now with
all tabs selected do CTRL F

"Suze" wrote:

I have separate worksheets for each month and would like to search the whole
workbook for specific data.

how do I search workbook for data
 

In the find options select Within "Workbook"


Gord Dibben MS Excel MVP

On Wed, 1 Apr 2009 10:54:02 -0700, Suze
wrote:

I have separate worksheets for each month and would like to search the whole
workbook for specific data.