In the attached workbooks in XL 2010, I have a room schedule for 2016, each workbook represents 1/4 of the year (Jan - Mar, Apr - June, etc.). I will need to print these out each day and right now, the page margins do not fit into 1 page per day. So I need the margins to fit one page per day.
In addition, I will need to copy the room extensions for each day for Guest 1, Guest 2 and Guest 3. So on the first day of each quarter for each workbook, I have the extensions for each guest room listed but will need this copied to all instances of each guest room, in the cell below the room name, for every day on each sheet in all books.