Developing a dynamic formula
The following formula requires that I substitute "10_29_2010" with another date,
e.g., "10_30_2010" that can be found in cell $A$1 formatted as a string.
What is the best way to include the contents of cell $A$1 into the formula so that the
='[Canvas_array.xlsx]10_29_2010'!$F$2
100's of formulas in the worksheet are now pointing to a new data source?
Last edited by SDruley; 11-04-2010 at 11:21 PM.
Turn Data into Information
Turn Information into Knowledge
Turn Knowledge into Direction
Turn Direction into Leadership
Turn Leadership into Results
Stephen Druley
It's not how quickly you think
But how deeply you think
The quality of thinking is measured
by remoteness to conformance
Stephen Druley
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks