How can i refer a running column in excel 2007? To explain it clearly, if i have an excel workbook which has 1000 columns each having future date values in one row (say row no 2), like 7-aug-2011, 14-aug-2011,21-aug-2011 and so on..
then is it possible to fetch the cell numbers B5, C5, D5 etc Based on the CURRENT date (in another workbook) , for example, if the date today is 7-aug-2011, i shud get the cell number B5, if the date today is 14-aug-2011, i shud get the cell number C5 and so on..?
---------------------------
At a higher level, is it possible to rotate the reference to a cell in Excel workbook based on the date value of a row data (in another workbook) and current date, as the date changes in the system, the reference the cell shud refer to a new column?
Any help will be much appreciated....
then is it possible to fetch the cell numbers B5, C5, D5 etc Based on the CURRENT date (in another workbook) , for example, if the date today is 7-aug-2011, i shud get the cell number B5, if the date today is 14-aug-2011, i shud get the cell number C5 and so on..?
---------------------------
At a higher level, is it possible to rotate the reference to a cell in Excel workbook based on the date value of a row data (in another workbook) and current date, as the date changes in the system, the reference the cell shud refer to a new column?
Any help will be much appreciated....
