Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
indirect help
Hello all - Hoping that someone with a little more experience can help
me out with this formula. Here is one of the formulas that I am trying to change. ='[September 06 Daily Report.xls]Service'!$E$3/P5 I keep one book per month so the next book will be called October 06 Daily Report.xls, I have a cell where I already have the month - ie September, for other purposes. What I would like to do is change my formula so that when I change the value in that cell it would also cahnge the formula. I have tried to use indirect but must still be doing something wrong because the only error that I get tells me that my formula has an error - not much help. Can anyone offer any suggestions to help me out? Thanks in advance, Terry |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
indirect help
Indirect can not be used with closed workbooks. There is an addin that might
be able to help you... http://xcell05.free.fr/ -- HTH... Jim Thomlinson "Terry K" wrote: Hello all - Hoping that someone with a little more experience can help me out with this formula. Here is one of the formulas that I am trying to change. ='[September 06 Daily Report.xls]Service'!$E$3/P5 I keep one book per month so the next book will be called October 06 Daily Report.xls, I have a cell where I already have the month - ie September, for other purposes. What I would like to do is change my formula so that when I change the value in that cell it would also cahnge the formula. I have tried to use indirect but must still be doing something wrong because the only error that I get tells me that my formula has an error - not much help. Can anyone offer any suggestions to help me out? Thanks in advance, Terry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
Indirect | Excel Worksheet Functions | |||
INDEX("a"&COLUMNS(INDIRECT(A1):INDIRECT(A2)):A30,4) | Excel Discussion (Misc queries) | |||
Please Help with INDIRECT | Excel Discussion (Misc queries) | |||
Help with INDIRECT() | Excel Discussion (Misc queries) |