I have attached a file. I'm looking for some suggestions if you have any. Also I'm looking for a way to do a few more things.

1st. I have a user form to add new people. I would like a way to automate creating a word document from a master doc, of the new persons name and having it hyperlinked to them in the spreadsheet. I have a form in word that I track information on employees. ( Or a better way of doing it also)

2nd. I currently have every day of the week thoughout the year refrenceing the info section. ( We have alot of changes in schedule) When I make a change it changes the history also. I.E. If I change Jeff's schedule in September. Jan thru Aug is also changed. Is there a way I can insert new information to each day for the future without changing the past? Some type of copy down from type of code? ( Not sure this makes sence)

Any other helpful hints on layout or better code would be nice. this is my first attempt at using VBA. I've had alot of help from here and other boards.

Thanks

Jeff