Insert menu...Define

[Guest]

In one of my worksheets, I have defined each of 32 NFL teams using some sort
of abbreviation, using "Insert...Name...Define".

Is it possible to copy (and paste) these abbreviations in the Names in
Workbook box
into another workbook???

In other words, I want to use my abbreviations in a workbook yet to be
constructed.

Thank you

 

[Bob Phillips]

Have you tried Jan Karel Pieterse's Name Managaer add-in, available at
http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.htm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Norman Jones]

Hi FL,

Copy any worksheet from the existing workbook to the new workbbook:

===================
Right-click worksheet tab
Move or Copy
Select the new workbook in the 'To book' dropdown box
Select the 'Create copy' option
====================

Copying a worksheet carries the source workbook names to the target
workbook.

The copied sheet can be deleted, if desired, without affecting the names in
the new workbook.

 

[Guest]

i knew this was possible...however my worksheet to be copied is huge!!

 

[Norman Jones]

Hi FL,

i knew this was possible...however my worksheet to be
copied is huge!!

Add a new worksheet to the names workbook.
Copy the blank sheet to the new workbook.