Usual blind-spot problems - Reference to rows in paras 1-3 should be as follows - hope that doesn't put anybody off! I have been provided with a spreadsheet, where Row 1 is a Header Row, A1=?Student name?, B1=?Current/Future Study Programme? and is then subdivided into groups of 6 rows. This means that Row 2 contains (Column A) ?Jane Smith?, (Column B) her Current Study Programme. Rows 3 to 7 are then (Column A) blank, and (Column B) Future Study Programme CHOICES numbered Ascending 1 to 5, i.e. B2=?1?, B3=?2?, B4=?3?, B5=?4?, B6=?5?. The whole pattern then repeats for ?John Smith? in Rows 8 to 13 and so on for 500 names! Graham ############################################################ Please consider the environment before printing this e-mail. This e-mail message, including any attachments, is for the sole use of the person to whom it has been sent and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail, and permanently delete this message and any attachments. Study Group makes no warranty that this e-mail is error or virus free. Study Group International Ltd, Registered in England, number 3108030, Registered office: 1 Billinton Way, Brighton, East Sussex BN1 4LF. Study Group International Ltd is the parent company of Bellerbys Educational Services and Embassy CES. ############################################################ ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, visit the group's homepage and use the dropdown menu at the top. This will allow you to unsubscribe your email address or change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to share files with the group, you must join our Yahoo sister group. This group will not allow for posting of emails, but will allow you to join and share problem files, templates, etc.: http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE SHARING ONLY. If you are using Outlook and you see a lot of unnecessary code in your email messages, read these instructions that explain why and how to fix it: http://personal-computer-tutor.com/abc3/v28/greg28.htm *************************************************************