Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
File Link
Can anyone help me solve this problem please. When I type a month in
cell "A1", say for example "August", how can I get it to change the "July" in the link below to "August". =+'[2XDA_Adults_Services July Monitoring Summary.xls]2XDB'!$P$73. Many thanks, Ola. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
File Link
You need the INDIRECT function.
Try =INDIRECT("'[2XDA_Adults_Services "&A1&" Monitoring Summary.xls]2XDB'!$P$73") And you don't need the + sign in your formula. [What do you want to add to what?] -- David Biddulph "Ola2B" wrote in message ups.com... Can anyone help me solve this problem please. When I type a month in cell "A1", say for example "August", how can I get it to change the "July" in the link below to "August". =+'[2XDA_Adults_Services July Monitoring Summary.xls]2XDB'!$P$73. Many thanks, Ola. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
File Link
The formula that David Biddulph gave you will work as long as that sending
workbook is open. As soon as you close that workbook (and excel recalcs), you'll get an error. If you're going to have that sending workbook closed, then Laurent Longre has an addin (morefunc.xll) at: http://xcell05.free.fr/ That includes =indirect.ext() that may help you. Ola2B wrote: Can anyone help me solve this problem please. When I type a month in cell "A1", say for example "August", how can I get it to change the "July" in the link below to "August". =+'[2XDA_Adults_Services July Monitoring Summary.xls]2XDB'!$P$73. Many thanks, Ola. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
File Link
On 27 Sep, 13:43, Dave Peterson wrote:
The formula that David Biddulph gave you will work as long as that sending workbook is open. As soon as you close that workbook (and excel recalcs), you'll get an error. If you're going to have that sending workbook closed, then Laurent Longre has an addin (morefunc.xll) at:http://xcell05.free.fr/ That includes =indirect.ext() that may help you. Ola2Bwrote: Can anyone help me solve this problem please. When I type a month in cell "A1", say for example "August", how can I get it to change the "July" in the link below to "August". =+'[2XDA_Adults_Services July Monitoring Summary.xls]2XDB'!$P$73. Many thanks, Ola. -- Dave Peterson Many thaks for your help Dave! The only problem i'm having now is that i keep getting this message "#name?" whenever i use the indirect and ext. formular. this is what i put in the cell : =INDIRECT.EXT("'[2XDA_Adults_Services "&G1&" Monitoring Summary.xls]2XDB'!$P$73"). Please let me know if i'm doing anything wrong. Many thanks, Ola. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
File Link
If you're getting that name error, then it looks like you didn't install that
addin correctly. I'd read the installation instructions once more and try installing again. Ola2B wrote: <<snipped Many thaks for your help Dave! The only problem i'm having now is that i keep getting this message "#name?" whenever i use the indirect and ext. formular. this is what i put in the cell : =INDIRECT.EXT("'[2XDA_Adults_Services "&G1&" Monitoring Summary.xls]2XDB'!$P$73"). Please let me know if i'm doing anything wrong. Many thanks, Ola. -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
File Link
On 4 Oct, 13:39, Dave Peterson wrote:
If you're getting that name error, then it looks like you didn't install that addin correctly. I'd read the installation instructions once more and try installing again. Ola2B wrote: <<snipped Many thaks for your help Dave! The only problem i'm having now is that i keep getting this message "#name?" whenever i use the indirect and ext. formular. this is what i put in the cell : =INDIRECT.EXT("'[2XDA_Adults_Services "&G1&" Monitoring Summary.xls]2XDB'!$P$73"). Please let me know if i'm doing anything wrong. Many thanks, Ola. -- Dave Peterson Thanks, I will try again. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link to wav file... | Excel Discussion (Misc queries) | |||
Is it possible to link cell formatting in Excel from file to file | Excel Discussion (Misc queries) | |||
Excel file link with word file | Excel Worksheet Functions | |||
xls spool file doesn't automatically link to new xls file | Excel Discussion (Misc queries) | |||
Link footer of one file to cells in another file | Excel Discussion (Misc queries) |