Copying the Names of Named Cells to another worksheet

  • Thread starter Thread starter Brandon
  • Start date Start date
B

Brandon

Hi everyone-

Is there any way that you can copy just the names of a range of named
cells from one workbook to a totally different file?

For instance - I name a row of cells something (like Jan-AcctsRec,
Feb-AcctsRec, etc.) on one spreadsheet in a file. Well, I want to copy
just the names of those named cells to another workbook. Is there any
way to just copy the names and paste them somewhere else?

Thanks in advance!
Brandon

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
 
You could insert a new worksheet in the same workbook and then
Insert|Name|paste|Paste list

Then copy and paste to that other workbook.

If you work with names a lot, do yourself a favor and get this addin:

Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager.

http://www.jkp-ads.com/Download.htm

Life will be a lot nicer!
 
Back
Top