Need A Macro To Copy Previous Tab to New Tab

Giganews Newsgroups
Subject: Need A Macro To Copy Previous Tab to New Tab
Posted by:  MGC
Date: Mon, 13 Aug 2007

Here we go:

I have several workbooks which contain daily timesheets for my employees.
Because the names of these employees seldom change from day to day, I would
like to know if there is a macro I could use to copy the previous days' tab
to a new tab which I could later rename.  The tabs are named according to the
job number (the date followed by a letter).

This is a huge project as I currently have 25+ jobs (workbooks) which need
time entered daily.  Any help you could provide would be great.  Thank you!

Replies