boxsterman
Active Member
- Joined
- Apr 16, 2002
- Messages
- 285
Hi all,
I want to link cells to another file based on the tab name. I have the name in cell s1 and want to combine this with an offset query as well based on the current period.
I'm having a little trouble figuring out exactly what the file should be
=OFFSET('C:\Documents and Settings\jbelitz\_Data\Desktop\FY06 forecast\files from controller\[Consolidated Forecast v7(bl).xls]GTA'!Q52,0,CurrentPeriod)/1000
I want to insert the indirect to replace the word GTA (which is the tab name) to reference cell S1.
Also, I will be mailing this out to several folks who won't have access to the above named file, I notice that when I close down the other file, the #Value error appears, is there anyway to keep the data there?
Thanks,
J.
I want to link cells to another file based on the tab name. I have the name in cell s1 and want to combine this with an offset query as well based on the current period.
I'm having a little trouble figuring out exactly what the file should be
=OFFSET('C:\Documents and Settings\jbelitz\_Data\Desktop\FY06 forecast\files from controller\[Consolidated Forecast v7(bl).xls]GTA'!Q52,0,CurrentPeriod)/1000
I want to insert the indirect to replace the word GTA (which is the tab name) to reference cell S1.
Also, I will be mailing this out to several folks who won't have access to the above named file, I notice that when I close down the other file, the #Value error appears, is there anyway to keep the data there?
Thanks,
J.