View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MGC MGC is offline
external usenet poster
 
Posts: 31
Default Need A Macro To Copy Previous Tab to New Tab

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!