ANmarS - Portfolio - MonthlyFile

Excel/VBA expert since Sep 1997 (21 years 2 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)

1055 downloads | Last updated: 1/15/2014

Screen shots (5)