i have a workbook with a names sheet that has all the info I need put onto timecard and a master sheet with the timecard that the employee will fill out how can I automaticly generate a new set of timecard each week. I need it to name the sheets with the employee's name on trhe tab so they can find their card and put all the info from the name sheet onto their card. As new names are added or deleted to the list whitch will be in alphabetical order it will make the new card with the names and the right info on each card from the list sheet how can I do this I am new to this and this is the last thing that need to be done.
One thing that is not clear is what happens to last week timesheet. Lets assume that this is just a template and every week you are making a copy to work off
This is how you can create your weekly time sheet
1. loop thru every name on sheet 1
2. for each name found, make a copy of master sheet and give it the same name as name found
3. put rest of the information
4. move to next name
I want to make it where when I update iton sunday I and print them out and it will delete the time sheets and then when I change the date it will automaticly generate the new time sheets for the next week. They will make each timesheet from the master sheet the master sheet will never change or be deleted. This way the new weeks timesheet will made automaticitly after the last weeks will be printed and be deleted. I am sending my Email if you write back I will send you what I have to show you ChemOpp@aol.com