Does anyone know if it's possible to transpose a vertical range of cells in, say, Sheet1, so that the names of new worksheets are automatically changed?
For example: Have the names of Sheets 2-6 automatically change to equal the values in range A1:A5 in Sheet1
Thanks
For example: Have the names of Sheets 2-6 automatically change to equal the values in range A1:A5 in Sheet1
Thanks