eelliott
06-03-2010, 08:51 AM
The attached spreadsheet includes macro code which prints multiple copies the same sheet, but varies the date in the footer. I created it because I needed to manually maintain a daily log sheet for my dog, but did not want to manually write the date at the bottom of each page.
Once the macro is invoked the user sets the start date and number of days.
My sheet is a single page but the code should work as is for a multi-page worksheet.
The concept could be expanded to be driven by something other than dates. For example, you need to print worksheet1 but drive it from a list of items (e.g., people, departments, buildings, equipment, etc.) contained in worksheet2 (or some other data source).
The attached spreadsheet is presently set to look from my security certificate, so you'll have to assign your own.
Ed
Once the macro is invoked the user sets the start date and number of days.
My sheet is a single page but the code should work as is for a multi-page worksheet.
The concept could be expanded to be driven by something other than dates. For example, you need to print worksheet1 but drive it from a list of items (e.g., people, departments, buildings, equipment, etc.) contained in worksheet2 (or some other data source).
The attached spreadsheet is presently set to look from my security certificate, so you'll have to assign your own.
Ed