Results 1 to 8 of 8

Automatically create new worksheet template daily with current date

Threaded View

  1. #1
    Registered User
    Join Date
    07-29-2016
    Location
    Dublin, Ireland
    MS-Off Ver
    2011
    Posts
    3

    Automatically create new worksheet template daily with current date

    I've created an Excel workshop to allow people track the different work activities they engage in over the working day (it's for a study we are doing). The idea is that everyone in my department will have a copy of the worksheet open on their computer at their desk and will record in realtime the different work activities they do over the day. I'm trying to make it as foolproof as possible by locking down everything except the cells they ned to complete.

    My problem is that I want Excel to create new worksheet everyday that is labelled with the current date. However, I want this worksheet to be the template I created (e.g. column headings, formulas, etc) rather than a completely blank worksheet. I also want Excel to either do this automatically when the workbook is opened each day or else have a button on the workbook that the person clicks to do it.

    I'm relatively new to Excel so have just been learning as I go along. I also don't have any knowledge of Visual Basic.

    I've attached a copy of the workbook (the password for both the sheet and the workbook is thescientist

    Any tips or help with this would be much appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Automatically create monthly totals from daily data
    By honeylhany143 in forum Excel General
    Replies: 2
    Last Post: 05-23-2014, 10:36 AM
  2. Automatically create Gmail with text, based on date entry in Excel worksheet
    By F1Fan in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-17-2012, 12:17 PM
  3. [SOLVED] Macro to create new worksheet from template and link to it from current cell?
    By chemoul in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-15-2012, 07:00 PM
  4. Automatically Create & Name New Worksheet Based On Cell Value (date)
    By clemsoncooz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-30-2011, 01:55 PM
  5. Daily Log (Open to Current Date)
    By wxman in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-03-2008, 01:26 PM
  6. Replies: 3
    Last Post: 03-01-2006, 11:40 AM
  7. Replies: 7
    Last Post: 10-19-2005, 11:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1