How can we look for a number in different spreadsheets?
 

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???

How can we look for a number in different spreadsheets?
 

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???

How can we look for a number in different spreadsheets?
 

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" wrote in message ...
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???

How can we look for a number in different spreadsheets?
 

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"
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

How can we look for a number in different spreadsheets?
 

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 ...
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"
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