ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Copy names to new worksheet (https://www.excelbanter.com/excel-worksheet-functions/122464-copy-names-new-worksheet.html)

rontiara

Copy names to new worksheet
 
I have named a series of cells in a spreadsheet and want to use those same
names in another worksheet in a different folder. But when I "copy all" the
names don't copy. I've tried using several "paste special" features, but
none of them allows for transferring the cell names to a new worksheet.

Roger Govier

Copy names to new worksheet
 
Hi

Copy the sheet to another book.
Right click on sheet tabMove or CopyClick copySelect new Book

--
Regards

Roger Govier


"rontiara" wrote in message
...
I have named a series of cells in a spreadsheet and want to use those
same
names in another worksheet in a different folder. But when I "copy
all" the
names don't copy. I've tried using several "paste special" features,
but
none of them allows for transferring the cell names to a new
worksheet.





All times are GMT +1. The time now is 12:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com