how do I search workbook for data

[Suze]

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

 

[Bob I]

Select all sheets first.

 

[Eduardo]

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

 

[Gord Dibben]

In the find options select Within "Workbook"


Gord Dibben MS Excel MVP