Using Excel 2002 and XP. Not sure how to pose this question. Has to do with one sheet referencing data from another sheet. My problem is that the sheet that I am importing data to is arranged on a row basis, i.e., c4,c5,c6 etc. The data is coming from a sheet arranged on a column basis, i.e., b4,b5,b6 etc. I would like to use the fill handle, on the receiving sheet, if possible. Otherwise it means referencing or copying each item of data as I go along. (It would be very inconvenient to rearrange the two sheets in the same format.) bille ************************************************************* 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, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************