Prev: setting scale on chart automatically
Next: Look up and return data
From: JLS on 9 Apr 2010 15:45
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: Jim Thomlinson on 9 Apr 2010 16:01
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 19:01
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: setting scale on chart automatically
Next: Look up and return data