AkaTrouble
Well-known Member
- Joined
- Dec 17, 2014
- Messages
- 1,544
Hello
limited skills excel user here trying to help even lower skilled friend offsite
i have created a workbook containing a "master" sheet which contains presently a predefined weekly planner Monday through Sunday
i have used some formula to show the days and dates based on a week start date field that presently is added manually, i also have some formatting for display etc and print area defined for printing on single sheet.
presently i create a new sheet copy and paste the contents of "master" or create copy of "master" rename the sheet to the start date and move to required place in page tabs.
what i would like to do is create an on opening event (i think this is what it is called) that checks todays date finds the Monday date for the week and checks if there is a page for this week and the next. If there is do nothing and if not create a sheet based on the "master" sheet and label it with the Monday date, then to check if there is a sheet = to next weeks Monday date and if not create it.
example todays date = 20th Dec 2014. so would need to check if there is a sheet named 15th Dec 2014 and also 22nd Dec 2014 (next week)
if not to create them with copy of contents of "master" sheet
hope i have explained this well enough
thanks for reading
limited skills excel user here trying to help even lower skilled friend offsite
i have created a workbook containing a "master" sheet which contains presently a predefined weekly planner Monday through Sunday
i have used some formula to show the days and dates based on a week start date field that presently is added manually, i also have some formatting for display etc and print area defined for printing on single sheet.
presently i create a new sheet copy and paste the contents of "master" or create copy of "master" rename the sheet to the start date and move to required place in page tabs.
what i would like to do is create an on opening event (i think this is what it is called) that checks todays date finds the Monday date for the week and checks if there is a page for this week and the next. If there is do nothing and if not create a sheet based on the "master" sheet and label it with the Monday date, then to check if there is a sheet = to next weeks Monday date and if not create it.
example todays date = 20th Dec 2014. so would need to check if there is a sheet named 15th Dec 2014 and also 22nd Dec 2014 (next week)
if not to create them with copy of contents of "master" sheet
hope i have explained this well enough
thanks for reading