Prev: Macro's
Next: Single Filter to change all Pivot Tables in a Workbook
From: TheTraveler on 9 Apr 2010 18:19
I may be showing my ignorance here, but can't you select all the tabs and
then use CTRL F? I don't have 800 tabs, but I do this often. I am also
looking for specific values or text, not formulas.
--
TheTraveler


"Jim Thomlinson" wrote:

> No...
> --
> HTH...
>
> Jim Thomlinson
>
>
> "JLS" wrote:
>
> > I need to lookup a number from one workbook to another, however, I want to
> > look up the value in ALL 800 tabs, not just the first tab. Is there a
> > formula that will allow me to look up the value in any tabs within a workbook?
From: Gord Dibben on 9 Apr 2010 20:27
That would be "finding" not "looking up" in the sense that OP may be
referring to VLOOKUP or INDEX/MATCH or similar function.

In your case of "finding" you don't need to select all the sheets.

Just set Find options to Within: workbook.


Gord Dibben MS Excel MVP

On Fri, 9 Apr 2010 15:19:02 -0700, TheTraveler
<TheTraveler(a)discussions.microsoft.com> wrote:

>I may be showing my ignorance here, but can't you select all the tabs and
>then use CTRL F? I don't have 800 tabs, but I do this often. I am also
>looking for specific values or text, not formulas.

From: JLatham on 10 Apr 2010 02:28
Time to think ... Access ??


"Gord Dibben" wrote:

> No.
>
> 800 sheets in a workbook!!!
>
>
> Gord Dibben MS Excel MVP
>
> On Fri, 9 Apr 2010 12:45:01 -0700, JLS <JLS(a)discussions.microsoft.com>
> wrote:
>
> >I need to lookup a number from one workbook to another, however, I want to
> >look up the value in ALL 800 tabs, not just the first tab. Is there a
> >formula that will allow me to look up the value in any tabs within a workbook?
>
> .
>
 | 
Pages: 1
Prev: Macro's
Next: Single Filter to change all Pivot Tables in a Workbook