Hello John, The macro will seem a little long but in my home it works fine. You only have to select the data, with the two lines of title and header included (easier to select properly, starting from the last line, I suggest, and bottom up). Dont paste the datas yourself, the macro does it the right way. Then you click on the macro, named 'beef_difficult_transfer' And that all. It works from any sheet, even full (it will erase) provided the selection in the web site is OK. Greetings form France, Jacques The Excel sheet with the Macro is in attachement -- Jacques De Schryver http://jdsetls.virtualave.net/ Last photo : http://shuttercity.com/ShowPhoto.cfm?PhotoID=51638 http://membres.lycos.fr/lsteven/ -- Binary/unsupported file stripped by Ecartis -- -- Type: application/vnd.ms-excel -- File: Beef_Rockmore.xls ************************************************************* 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?Subject=unsubscribe 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 *************************************************************