Hi Guys

How can we look for a number in different spreadsheets? For example, I
have 10 spreadsheets in a workbook (all of them with data) and I want
to look for a number or a name while I do not know in which
spreadsheet this numer or name is, how can I look for it? I know we
cannot use Ctrl + F, as it only works in the active spreadsheet. Any
help???

hi
yes you can.
on the find dialog, click options. in the within combo box, choose workbook.
the find will now search the entire workbook.
i am not sure when this feature was introduced but i am fairly certain i was
using it in 2000 and now in 2003. not sure about 2007 but i can see why MS
would remove it.
if your version of excel don't have the option feature see this site.
http://www.jkp-ads.com/officemarketplaceff-en.asp
it's a free addin called flexfind and it will search the entire workbook.

Regards
FSt1

"nish" wrote:

> Hi Guys
>
> How can we look for a number in different spreadsheets? For example, I
> have 10 spreadsheets in a workbook (all of them with data) and I want
> to look for a number or a name while I do not know in which
> spreadsheet this numer or name is, how can I look for it? I know we
> cannot use Ctrl + F, as it only works in the active spreadsheet. Any
> help???
>

I believe 2002 is the first version with this option

The OP can select all sheets and use Find
(right click on a sheet tab and choose select all sheets)

Do not forget to ungroup the sheets after the search


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"FSt1" <(E-Mail Removed)> wrote in message news0764405-2AFA-4F67-847F-(E-Mail Removed)...
> hi
> yes you can.
> on the find dialog, click options. in the within combo box, choose workbook.
> the find will now search the entire workbook.
> i am not sure when this feature was introduced but i am fairly certain i was
> using it in 2000 and now in 2003. not sure about 2007 but i can see why MS
> would remove it.
> if your version of excel don't have the option feature see this site.
> http://www.jkp-ads.com/officemarketplaceff-en.asp
> it's a free addin called flexfind and it will search the entire workbook.
>
> Regards
> FSt1
>
> "nish" wrote:
>
>> Hi Guys
>>
>> How can we look for a number in different spreadsheets? For example, I
>> have 10 spreadsheets in a workbook (all of them with data) and I want
>> to look for a number or a name while I do not know in which
>> spreadsheet this numer or name is, how can I look for it? I know we
>> cannot use Ctrl + F, as it only works in the active spreadsheet. Any
>> help???
>>

Ron

In 97 Find would not work across grouped sheets.

Replace would work across grouped sheets........go figure<g>


Gord

On Fri, 25 Jul 2008 01:53:55 +0200, "Ron de Bruin" <(E-Mail Removed)>
wrote:

>I believe 2002 is the first version with this option
>
>The OP can select all sheets and use Find
>(right click on a sheet tab and choose select all sheets)
>
>Do not forget to ungroup the sheets after the search

Hi Gord

Thanks
Now I remember about 97

To many Excel versions now to remember all problems <g>
I hope the OP use 2000


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gord Dibben" <gorddibbATshawDOTca> wrote in message news:(E-Mail Removed)...
> Ron
>
> In 97 Find would not work across grouped sheets.
>
> Replace would work across grouped sheets........go figure<g>
>
>
> Gord
>
> On Fri, 25 Jul 2008 01:53:55 +0200, "Ron de Bruin" <(E-Mail Removed)>
> wrote:
>
>>I believe 2002 is the first version with this option
>>
>>The OP can select all sheets and use Find
>>(right click on a sheet tab and choose select all sheets)
>>
>>Do not forget to ungroup the sheets after the search
>