Hello friends,
I need your help, once again!
I shall give brief about my task, might give you a better understanding.
I have a excel file with data over many sheets, etc. it's a server based automatic update workbook. and everyday, once a day the update takes place. and according to the day on which the update has been done, a new sheet with that day's date is created, which has detailed information.
eg: '02/09/2012!' is the new hidden sheet.
I have a hidden sheet, where i want to automatically update the dates vertically without manually.
so, i want a list to be created in this way,
'02/09/2012!'
'01/09/2012!'
...
...
..
'30/08/2012!'
latest to the oldest. and automatically they hv to shift...
any doubts, please ask. But i need your help asap!!
I need your help, once again!
I shall give brief about my task, might give you a better understanding.
I have a excel file with data over many sheets, etc. it's a server based automatic update workbook. and everyday, once a day the update takes place. and according to the day on which the update has been done, a new sheet with that day's date is created, which has detailed information.
eg: '02/09/2012!' is the new hidden sheet.
I have a hidden sheet, where i want to automatically update the dates vertically without manually.
so, i want a list to be created in this way,
'02/09/2012!'
'01/09/2012!'
...
...
..
'30/08/2012!'
latest to the oldest. and automatically they hv to shift...
any doubts, please ask. But i need your help asap!!
