Saving an Excel File from 'Template' RRS feed

  • Question

  • I've created a 'Time Sheet' file where a manager can pick the employee name from a list (in Cell C4).  The tab is named 'Timesheet template'.  I'd like to create a simple vba macro be able to make a copy of this tab, move it to the end of the list of tabs (in alphabetic order if possible), and name it from the data in Cell C4.

    On another similar note, I'm also looking to be able to save the entire file when completed, based on a name based on the time period (for example, 'Timesheet - Week Beginning 2013-02-18), which is based on data in another cell (C77).  The original file will already exist, named as 'Timesheet Version 1'.  Any clues?  Thanks.

    • Moved by Quist Zhang Wednesday, February 27, 2013 3:09 AM Off-topic
    Tuesday, February 26, 2013 9:44 PM

All replies