|
nested Indirect to other WS
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 |
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" wrote in message ... 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 |
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" wrote in message ... 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 |
Try this:
=AVERAGE(INDIRECT("'[Master.xls]RMG'!B"&AB1623&":B"&ab1624)) Just remember, Master.xls MUST be open for this to work. Biff "LyleF" wrote in message ... 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" wrote in message ... 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
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" wrote in message ... 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" wrote in message ... 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 |
| All times are GMT +1. The time now is 05:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com