Adding new Timesheet from a list

[OAM]

I am using the code below (Excel 2007) to delete and add back timesheets based on a list of names from the “Names” tab. In addition, I am making a “Table of Contents” with hyperlinks on a separate worksheet that will allow employees quick access to their timesheet without having to look at each tab. The code below works well if I want to delete and add back all the timesheet at one time but if we get a new employee in the middle of a pay period I have to use a single timesheet until the end of the pay period.

What I would like to know is, can the code below be modified so that when the code is run it reviews the list of names and only adds a new timesheet for that employee without deleting and adding back all the timesheets?

Please Login or Register  to view this content.

[LJMetzger]

Hi OAM,

See the attached workbook (written and tested in Excel 2003) based on your original code. It has macros to:
a. Make the 'Names' Sheet visible (needed for testing).
b. Delete all TimeSheets and add TimeSheets based on the 'Names' Sheet (existing capability). This also adds the capability of checking for 'duplicate names' on the 'Names' Sheet.
c. Add TimeSheets from the 'Names' Sheet only if the TimeSheet does NOT exist.
d. Sort the TimeSheets in ascending order.

Please note that I created stub routines for 'DelSht() (I don't know what this is supposed to do) and 'CreateTableOfContents()'.

There are command buttons on the 'Names' Sheet for items b. thru d. above.

Lewis

The code follows:

Please Login or Register  to view this content.