arnab0711
03-27-2012, 12:58 AM
Hi,
I have this final sheet where there is a formula from N4-O8,my query is regarding the date part at the end of the formula.
The date formula changes at each change in dropdown tab in graph sheet.
each time the date changes the cell N1 of final sheet also changes.
My problem - At the current stage in graph sheet Aug-11 is selected and subsequently somefigures are updated in cells N4-o8 of final sheet but wheen you go to the source you will see non of the datas pertain to Aug-11
all are from Jan -12,but still figures are showing,how is that possible.
I have this final sheet where there is a formula from N4-O8,my query is regarding the date part at the end of the formula.
The date formula changes at each change in dropdown tab in graph sheet.
each time the date changes the cell N1 of final sheet also changes.
My problem - At the current stage in graph sheet Aug-11 is selected and subsequently somefigures are updated in cells N4-o8 of final sheet but wheen you go to the source you will see non of the datas pertain to Aug-11
all are from Jan -12,but still figures are showing,how is that possible.