You first enter the starting date, then Excel will know which week, with which dates Week number 1 will have, e.g. Starting date is 1st of March, Week number 1 would be from the 1st of March to 6th of March. However, I do not know how to make Excel read a calender or from where i can get the calender inserted and how to get the 7 dates to go into specific cells on a worksheet then have those dates placed next to their days, so 3rd of March would be placed next to Sunday. Could you plz help me out here.
Plus i want to have a certain sheet replaced by a clear one each week(not a blank sheet obviously, just no data), i can make this a template and have a macro open it, but is there a way to make it so that when the macro is used to open the template the workbook is saved as
"week number"Worksheet.xls automatically. In a year i would need about 50+ of the sheets, how do i get Excel to automatically update the drop down list with the week numbers in them and get the week number linked to the correct worksheet representing the data for that weeks worksheet automatically.
Would be great if you could help me out on any of this thx

[ This Message was edited by: Keiju on 2002-03-19 10:12 ]