How can we look for a number in different workbooks?
 

Hi Guys

How can we look for a number in different workbooks? For example, I
have 10 workbooks opened on my desktop and I want to look for a number
or a name while I do not know in which workboo 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.

How can we look for a number in different workbooks?
 

http://www.microsoft.com/communities...r=US&sloc=&p=1


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"nish" wrote:

Hi Guys

How can we look for a number in different workbooks? For example, I
have 10 workbooks opened on my desktop and I want to look for a number
or a name while I do not know in which workboo 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.

How can we look for a number in different workbooks?
 

On Jul 24, 2:41*pm, Wigi wrote:
http://www.microsoft.com/communities...efault.aspx?dg...

--
Wigihttp://www.wimgielis.be= Excel/VBA, soccer and music



"nish" wrote:
Hi Guys

How can we look for a number in different workbooks? For example, I
have 10 workbooks opened on my desktop and I want to look for a number
or a name while I do not know in which workboo 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.- Hide quoted text -

- Show quoted text -



Hi...It is only for one workbook......what if we are working with
multiple workbooks.....