ANmarS - Portfolio - MonthlyFile

Excel/VBA expert since Sep 1997 (20 years 10 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

MonthlyFile    Added: 4/17/2012 | Created: 4/5/2012   

Creates daily sheets for a single month (once set the year and month in main sheet and clicked on 'Create Days')
A custom made Simple macro file that will organize the process of daily activities for up to three shifts in any business (restaurant, office, etc)
It has three sections:
Section one: Creates the full selected month days as sheets, one sheet per day using sheet named '1' that should be already set.
Section two: Copies the Managers/Users list if it changed to days after, once user clicks on one of 3 buttons (colored circle next to that shift title), it copeis the list of users/managers for that shift into all future days.
Section Three: Copies the whole shift data into all days past and future.

Download (40.4 KB)

1044 downloads | Last updated: 1/15/2014

Screen shots (5)