Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Named Ranges
I have a series of workbooks (6) that feed into a summary book. All workbooks
are identical. I have added alot of named ranges into workbook #1 and would like to know if there is a way to import or copy the range names into the other workbooks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Named Ranges
If the workbooks are identical, why not select all cells, copy and paste
special (formulas), into the new workbook. "Tom Perlman" wrote: I have a series of workbooks (6) that feed into a summary book. All workbooks are identical. I have added alot of named ranges into workbook #1 and would like to know if there is a way to import or copy the range names into the other workbooks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Named Ranges
Get hold of Jan Karel Pieterse's NameManager utility, v4 will do that for
you http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Tom Perlman" <Tom wrote in message ... I have a series of workbooks (6) that feed into a summary book. All workbooks are identical. I have added alot of named ranges into workbook #1 and would like to know if there is a way to import or copy the range names into the other workbooks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Named Ranges
The workbooks are updated weekly with unique data even though the formulas
are identical. Because this has been a "work in process" I would have to copy/paste a lot of data into the sheets. Thanks...... "Antney" wrote: If the workbooks are identical, why not select all cells, copy and paste special (formulas), into the new workbook. "Tom Perlman" wrote: I have a series of workbooks (6) that feed into a summary book. All workbooks are identical. I have added alot of named ranges into workbook #1 and would like to know if there is a way to import or copy the range names into the other workbooks. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Named Ranges
Bob,
NameManager utility, v4 was exactly what I needed. Thanks for the tip....... "Bob Phillips" wrote: Get hold of Jan Karel Pieterse's NameManager utility, v4 will do that for you http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Tom Perlman" <Tom wrote in message ... I have a series of workbooks (6) that feed into a summary book. All workbooks are identical. I have added alot of named ranges into workbook #1 and would like to know if there is a way to import or copy the range names into the other workbooks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named ranges which seem to reference old workbooks/worksheets | Excel Discussion (Misc queries) | |||
Using Query and expanding named ranges | Excel Discussion (Misc queries) | |||
Named ranges: don't want absolute references | Excel Discussion (Misc queries) | |||
Named Ranges shown (or not shown) as blue means what? | Excel Worksheet Functions | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |