nested Indirect to other WS

Biff · 09-06-2005, 01:05 AM

Hi!

Try this:

:=AVERAGE(Indirect("'[Master.xls]RMG'!"&AB1623&":"&AB1624))

Note - if this is being used in TEST.XLS then MASTER.XLS must be open for it
to work.

Biff

"LyleF" <LyleF@discussions.microsoft.com> wrote in message
news:EED5855E-18AD-4E29-BFC3-F2C8AA281A3D@microsoft.com...
>I am using Indirect fine within the WS 'Test' but cannot get it to grab
>info
> from another WS within a nested function. Ex:
> =AVERAGE('[Master.xls]RMG'!B1300:B1617) which works fine. I want the
> b1330:b1617 to be an indirect call from the original worksheet 'Test'.
> ex:=AVERAGE(Indirect('[Master.xls]RMG'!"AB"(&1623)&":AB"(&1624))). This
> gives me a highlight error at "AB".
> Thanks
> Lyle

LyleF · 09-06-2005, 01:05 AM

That's closer to what I need. I forgot to say I need to imbed the column B
before the ab1623 and ab1624 - kind of a big miss on my part. So the formula
would read
=AVERAGE(INDIRECT("'[Master.xls]RMG'!"B"&AB1623&":"B"&ab1624)) or something
like that?? This of course doesn't work. I can't get the punctuation right.

Text.xls is always pulling from column B in all the tabs in Master.xls
--
Thanks for your help
Lyle

"Biff" wrote:

> Hi!
>
> Try this:
>
> :=AVERAGE(Indirect("'[Master.xls]RMG'!"&AB1623&":"&AB1624))
>
> Note - if this is being used in TEST.XLS then MASTER.XLS must be open for it
> to work.
>
> Biff
>
> "LyleF" <LyleF@discussions.microsoft.com> wrote in message
> news:EED5855E-18AD-4E29-BFC3-F2C8AA281A3D@microsoft.com...
> >I am using Indirect fine within the WS 'Test' but cannot get it to grab
> >info
> > from another WS within a nested function. Ex:
> > =AVERAGE('[Master.xls]RMG'!B1300:B1617) which works fine. I want the
> > b1330:b1617 to be an indirect call from the original worksheet 'Test'.
> > ex:=AVERAGE(Indirect('[Master.xls]RMG'!"AB"(&1623)&":AB"(&1624))). This
> > gives me a highlight error at "AB".
> > Thanks
> > Lyle
>
>
>

Biff · 09-06-2005, 01:05 AM

Try this:

=AVERAGE(INDIRECT("'[Master.xls]RMG'!B"&AB1623&":B"&ab1624))

Just remember, Master.xls MUST be open for this to work.

Biff

"LyleF" <LyleF@discussions.microsoft.com> wrote in message
news:EE679ECE-1B6D-4E2C-BF9B-5B4D15C78BC5@microsoft.com...
> That's closer to what I need. I forgot to say I need to imbed the column
> B
> before the ab1623 and ab1624 - kind of a big miss on my part. So the
> formula
> would read
> =AVERAGE(INDIRECT("'[Master.xls]RMG'!"B"&AB1623&":"B"&ab1624)) or
> something
> like that?? This of course doesn't work. I can't get the punctuation
> right.
>
> Text.xls is always pulling from column B in all the tabs in Master.xls
> --
> Thanks for your help
> Lyle
>
>
> "Biff" wrote:
>
>> Hi!
>>
>> Try this:
>>
>> :=AVERAGE(Indirect("'[Master.xls]RMG'!"&AB1623&":"&AB1624))
>>
>> Note - if this is being used in TEST.XLS then MASTER.XLS must be open for
>> it
>> to work.
>>
>> Biff
>>
>> "LyleF" <LyleF@discussions.microsoft.com> wrote in message
>> news:EED5855E-18AD-4E29-BFC3-F2C8AA281A3D@microsoft.com...
>> >I am using Indirect fine within the WS 'Test' but cannot get it to grab
>> >info
>> > from another WS within a nested function. Ex:
>> > =AVERAGE('[Master.xls]RMG'!B1300:B1617) which works fine. I want the
>> > b1330:b1617 to be an indirect call from the original worksheet 'Test'.
>> > ex:=AVERAGE(Indirect('[Master.xls]RMG'!"AB"(&1623)&":AB"(&1624))).
>> > This
>> > gives me a highlight error at "AB".
>> > Thanks
>> > Lyle
>>
>>
>>

LyleF · 09-06-2005, 01:05 AM

Biff

Thanks for your time. It works perfectly, as you knew it would.
--
Thanks
Lyle

"Biff" wrote:

> Try this:
>
> =AVERAGE(INDIRECT("'[Master.xls]RMG'!B"&AB1623&":B"&ab1624))
>
> Just remember, Master.xls MUST be open for this to work.
>
> Biff
>
> "LyleF" <LyleF@discussions.microsoft.com> wrote in message
> news:EE679ECE-1B6D-4E2C-BF9B-5B4D15C78BC5@microsoft.com...
> > That's closer to what I need. I forgot to say I need to imbed the column
> > B
> > before the ab1623 and ab1624 - kind of a big miss on my part. So the
> > formula
> > would read
> > =AVERAGE(INDIRECT("'[Master.xls]RMG'!"B"&AB1623&":"B"&ab1624)) or
> > something
> > like that?? This of course doesn't work. I can't get the punctuation
> > right.
> >
> > Text.xls is always pulling from column B in all the tabs in Master.xls
> > --
> > Thanks for your help
> > Lyle
> >
> >
> > "Biff" wrote:
> >
> >> Hi!
> >>
> >> Try this:
> >>
> >> :=AVERAGE(Indirect("'[Master.xls]RMG'!"&AB1623&":"&AB1624))
> >>
> >> Note - if this is being used in TEST.XLS then MASTER.XLS must be open for
> >> it
> >> to work.
> >>
> >> Biff
> >>
> >> "LyleF" <LyleF@discussions.microsoft.com> wrote in message
> >> news:EED5855E-18AD-4E29-BFC3-F2C8AA281A3D@microsoft.com...
> >> >I am using Indirect fine within the WS 'Test' but cannot get it to grab
> >> >info
> >> > from another WS within a nested function. Ex:
> >> > =AVERAGE('[Master.xls]RMG'!B1300:B1617) which works fine. I want the
> >> > b1330:b1617 to be an indirect call from the original worksheet 'Test'.
> >> > ex:=AVERAGE(Indirect('[Master.xls]RMG'!"AB"(&1623)&":AB"(&1624))).
> >> > This
> >> > gives me a highlight error at "AB".
> >> > Thanks
> >> > Lyle
> >>
> >>
> >>
>
>
>

LyleF · 09-06-2005, 07:05 AM

I am using Indirect fine within the WS 'Test' but cannot get it to grab info
from another WS within a nested function. Ex:
=AVERAGE('[Master.xls]RMG'!B1300:B1617) which works fine. I want the
b1330:b1617 to be an indirect call from the original worksheet 'Test'.
ex:=AVERAGE(Indirect('[Master.xls]RMG'!"AB"(&1623)&":AB"(&1624))). This
gives me a highlight error at "AB".
Thanks
Lyle

Biff · 09-06-2005, 07:05 AM

Hi!

Try this:

:=AVERAGE(Indirect("'[Master.xls]RMG'!"&AB1623&":"&AB1624))

Note - if this is being used in TEST.XLS then MASTER.XLS must be open for it
to work.

Biff

"LyleF" <LyleF@discussions.microsoft.com> wrote in message
news:EED5855E-18AD-4E29-BFC3-F2C8AA281A3D@microsoft.com...
>I am using Indirect fine within the WS 'Test' but cannot get it to grab
>info
> from another WS within a nested function. Ex:
> =AVERAGE('[Master.xls]RMG'!B1300:B1617) which works fine. I want the
> b1330:b1617 to be an indirect call from the original worksheet 'Test'.
> ex:=AVERAGE(Indirect('[Master.xls]RMG'!"AB"(&1623)&":AB"(&1624))). This
> gives me a highlight error at "AB".
> Thanks
> Lyle

LyleF · 09-06-2005, 07:05 AM

That's closer to what I need. I forgot to say I need to imbed the column B
before the ab1623 and ab1624 - kind of a big miss on my part. So the formula
would read
=AVERAGE(INDIRECT("'[Master.xls]RMG'!"B"&AB1623&":"B"&ab1624)) or something
like that?? This of course doesn't work. I can't get the punctuation right.

Text.xls is always pulling from column B in all the tabs in Master.xls
--
Thanks for your help
Lyle

"Biff" wrote:

> Hi!
>
> Try this:
>
> :=AVERAGE(Indirect("'[Master.xls]RMG'!"&AB1623&":"&AB1624))
>
> Note - if this is being used in TEST.XLS then MASTER.XLS must be open for it
> to work.
>
> Biff
>
> "LyleF" <LyleF@discussions.microsoft.com> wrote in message
> news:EED5855E-18AD-4E29-BFC3-F2C8AA281A3D@microsoft.com...
> >I am using Indirect fine within the WS 'Test' but cannot get it to grab
> >info
> > from another WS within a nested function. Ex:
> > =AVERAGE('[Master.xls]RMG'!B1300:B1617) which works fine. I want the
> > b1330:b1617 to be an indirect call from the original worksheet 'Test'.
> > ex:=AVERAGE(Indirect('[Master.xls]RMG'!"AB"(&1623)&":AB"(&1624))). This
> > gives me a highlight error at "AB".
> > Thanks
> > Lyle
>
>
>

Biff · 09-06-2005, 07:05 AM

Try this:

=AVERAGE(INDIRECT("'[Master.xls]RMG'!B"&AB1623&":B"&ab1624))

Just remember, Master.xls MUST be open for this to work.

Biff

"LyleF" <LyleF@discussions.microsoft.com> wrote in message
news:EE679ECE-1B6D-4E2C-BF9B-5B4D15C78BC5@microsoft.com...
> That's closer to what I need. I forgot to say I need to imbed the column
> B
> before the ab1623 and ab1624 - kind of a big miss on my part. So the
> formula
> would read
> =AVERAGE(INDIRECT("'[Master.xls]RMG'!"B"&AB1623&":"B"&ab1624)) or
> something
> like that?? This of course doesn't work. I can't get the punctuation
> right.
>
> Text.xls is always pulling from column B in all the tabs in Master.xls
> --
> Thanks for your help
> Lyle
>
>
> "Biff" wrote:
>
>> Hi!
>>
>> Try this:
>>
>> :=AVERAGE(Indirect("'[Master.xls]RMG'!"&AB1623&":"&AB1624))
>>
>> Note - if this is being used in TEST.XLS then MASTER.XLS must be open for
>> it
>> to work.
>>
>> Biff
>>
>> "LyleF" <LyleF@discussions.microsoft.com> wrote in message
>> news:EED5855E-18AD-4E29-BFC3-F2C8AA281A3D@microsoft.com...
>> >I am using Indirect fine within the WS 'Test' but cannot get it to grab
>> >info
>> > from another WS within a nested function. Ex:
>> > =AVERAGE('[Master.xls]RMG'!B1300:B1617) which works fine. I want the
>> > b1330:b1617 to be an indirect call from the original worksheet 'Test'.
>> > ex:=AVERAGE(Indirect('[Master.xls]RMG'!"AB"(&1623)&":AB"(&1624))).
>> > This
>> > gives me a highlight error at "AB".
>> > Thanks
>> > Lyle
>>
>>
>>

LyleF · 09-06-2005, 07:05 AM

Biff

Thanks for your time. It works perfectly, as you knew it would.
--
Thanks
Lyle

"Biff" wrote:

> Try this:
>
> =AVERAGE(INDIRECT("'[Master.xls]RMG'!B"&AB1623&":B"&ab1624))
>
> Just remember, Master.xls MUST be open for this to work.
>
> Biff
>
> "LyleF" <LyleF@discussions.microsoft.com> wrote in message
> news:EE679ECE-1B6D-4E2C-BF9B-5B4D15C78BC5@microsoft.com...
> > That's closer to what I need. I forgot to say I need to imbed the column
> > B
> > before the ab1623 and ab1624 - kind of a big miss on my part. So the
> > formula
> > would read
> > =AVERAGE(INDIRECT("'[Master.xls]RMG'!"B"&AB1623&":"B"&ab1624)) or
> > something
> > like that?? This of course doesn't work. I can't get the punctuation
> > right.
> >
> > Text.xls is always pulling from column B in all the tabs in Master.xls
> > --
> > Thanks for your help
> > Lyle
> >
> >
> > "Biff" wrote:
> >
> >> Hi!
> >>
> >> Try this:
> >>
> >> :=AVERAGE(Indirect("'[Master.xls]RMG'!"&AB1623&":"&AB1624))
> >>
> >> Note - if this is being used in TEST.XLS then MASTER.XLS must be open for
> >> it
> >> to work.
> >>
> >> Biff
> >>
> >> "LyleF" <LyleF@discussions.microsoft.com> wrote in message
> >> news:EED5855E-18AD-4E29-BFC3-F2C8AA281A3D@microsoft.com...
> >> >I am using Indirect fine within the WS 'Test' but cannot get it to grab
> >> >info
> >> > from another WS within a nested function. Ex:
> >> > =AVERAGE('[Master.xls]RMG'!B1300:B1617) which works fine. I want the
> >> > b1330:b1617 to be an indirect call from the original worksheet 'Test'.
> >> > ex:=AVERAGE(Indirect('[Master.xls]RMG'!"AB"(&1623)&":AB"(&1624))).
> >> > This
> >> > gives me a highlight error at "AB".
> >> > Thanks
> >> > Lyle
> >>
> >>
> >>
>
>
>