Try recording a macro in which you create a new worksheet, and rename it toanother name.Then use this macro as a template to loop through the cell names on sheet1.