|Subject:||Indirect cell references ????|
|Posted by:||Stephen Rainey (stephenrain…@hotmail.com)|
|Date:||Tue, 2 May 2006|
I have looked far and wide for an answer to this issue, and
I am hoping that someone here can help.
I create "summary" sheets of workbooks so that important information can be
seen at a glance on one page.
In order to simplify the preparation of summary sheets, I want to be able
to use the date value in column A
to derive the name of the books and sheets referenced in adjacent cells.
When attempting to concatenate text and date functions, the formula do not
resolve, not sure what I am doing wrong.
I hope the following illustration conveys my meaning.
Any help will be appreciated.
Date Orders Received
Fuel Used Widgets Shipped
01 24-Dec =[book12]sheet24$A$1
12 02-Aug =[book08]sheet02$A$1
13 01-Aug =[book08]sheet01$A$1
14 31-Jul =[book07]sheet31$A$1
21 15-May =[book05]sheet15$A%1
My attempt to put this in a formula is as follows. However it does not
resolve as is desired.
P.S. I am also have trouble getting the date functions to resolve to 2
digit day and month values.