Project Description:
Creation of a Button what calculates a summary of all pages into on page, saves this on the Summary Page, sends it via email, Dropbox and stores it on the local drive, clears the summary page for entry the following day.
Additional Project Description:
02/07/2013 at 22:18 EST
I have a Excel spread sheet with about 15 sheets to it. I require a Button which when clicked will copy specific information from each sheet to a Summary Sheet (Which you will create) It will then email the Summary Sheet and Daily Log Sheet to a specific email address, it will also save these 2 sheets into a location on the hard drive and to Drop Box. It will then close the original file clearing the Daily Log but Saving any information stored on any other sheet.