Hi all, This is a tricky one. I have an Excel 2010 workbook with two sheets. they both contain the same data but each is sorted differently. the first by an ID for assignment groups, the second alphabetically. What I want to do is to enter a grade for an assignment in sheet 1, and have the appropriate cell in sheet 2 updated. I'm sure it's possible to do this I just don't know how. Any help appreciated. Dónal Dr. Dónal Fitzpatrick, School of Computing, Dublin City University, Glasnevin, Dublin 9, Ireland Tel. +353-(0)1-700-8929 fax: +353-(0)1-700-5442 email: dfitzpat (at) computing.dcu.ie Email Disclaimer "This e-mail and any files transmitted with it are confidential and are intended solely for use by the addressee. Any unauthorised dissemination, distribution or copying of this message and any attachments is strictly prohibited. If you have received this e-mail in error, please notify the sender and delete the message. Any views or opinions presented in this e-mail may solely be the views of the author and cannot be relied upon as being those of Dublin City University. E-mail communications such as this cannot be guaranteed to be virus-free, timely, secure or error-free and Dublin City University does not accept liability for any such matters or their consequences. Please consider the environment before printing this e-mail." ==========================================================The vicsireland mailing list To unsubscribe at any time send a mail to: vicsireland-request@xxxxxxxxxxxxx with the word "unsubscribe", without the quotes in the subject of the message. To contact the moderator send mail to: tim.j.culhane@xxxxxxxxx For mor information on the Visually Impaired Computer Society visit: http://www.vicsireland.org