i need to create column headings that display the 12 months. the first column would be a FY starting month selected by the user in a data validation field. columns to the right would then populate with sequential months, one month per column. FY starting month can be any of the 12 months. my trouble is restarting back to January when the start date is something other than January. Actual years do not need to be noted, only the months.
i could have the user select the fiscal ending month instead of the fiscal starting month if that makes it any easier.
Thanks.
Bookmarks