In the attached Excel file, it is possible for the user to select the day he/she goes to work, and then click a button, which creates a rotation for the remainder of the year, in order to see when user will home and when user will be away.
It was initially made for just one year at the time, but now a second year has been added. Problem is that I can't seem to get the code changed, in order for both years to come in to use. If I e.g. select August 23, 2010, and click the '28' days button, then 28 days should be shaded, with 28 'empty' days in between, all the way until the end of the second year (in the file 2011).
Can someone explain/assist with getting this working?
Thanks.
/Anders
Bookmarks