+ Reply to Thread
Results 1 to 2 of 2

create copies of a worksheet using VBA

  1. #1
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Cardiff
    MS-Off Ver
    2003
    Posts
    123

    create copies of a worksheet using VBA

    I have a workbook that is used in our team for our time recording. Everyone has their own workbook, and they can keep track of clocking in and out.

    Each sheet references the previous sheet to keep a running total of the flexi-time that person has. The sheet has others thigs in it, such as a message when the time for lunch entered is less than 00:30:00.

    What I am hoping to do is to find a way to add another sheet to each work book easily. At the moment I have to copy the sheet, delete any times already entered and then change all of the dates.

    I am completely new to VBA, but can't think of a way to do this without using it. If anyone can help then ta very much.
    Attached Files Attached Files

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: create copies of a worksheet using VBA

    Create a template sheet. See how this works in the Summary Sheet example here

    http://www.excel-it.com/workbook_downloads.htm
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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