I have added roster.xls for further explaination I have 2 worksheets
The first is for printing out the timtable for easy reading The second is for adding the schedule on teachers etc in an easy to use in line format This document would be held on a public folder, I would normally protect the first page and people can add print it off whilst a data entry person would add the data to the second schedule sheet. Data entry can be entered or copied and pasted but it looses the link if draged and droped. Can someone please help resolve the drag and drop issue. Thanks Phil --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---