1 Attachment(s)
Update Calendar Fills by Revolving Sequence Using VBA
Hi there all
I have a spread sheet that generates a calendar and I have a 28 day cycle menu that i need to link to the callendar days. currently i read in manually in bold under the dates.
Can someone assist to enable me to in any year and any month to read in a specific menu number and the rest will be populated and outomatically populate any other chosen year or month there after until i clear to restart. the menu repeats after menu no 28 and start again at 1.
menu 1 always starts on a monday and so on...meaning certain menus falls under certain days........1,8,14,21= can only fall on mondays
I would like a warning buit in if the menu no's dont correspond to the right callendar days too.
would also like the clear menus button to clear all menus that have been read in
please help