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.

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

On Jul 24, 2:41*pm, Wigi <W...@discussions.microsoft.com> 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.....