ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   workbook level name vs worksheet level name (https://www.excelbanter.com/excel-programming/397740-workbook-level-name-vs-worksheet-level-name.html)

clara

workbook level name vs worksheet level name
 
Hi there,

By accident, there are two set of names in my workbook, workbook level and
worksheet level( existing in some worksheets) and the two set are same. how
can just change the worksheet level names into workbook level names ?

Clara
--
thank you so much for your help

Charles Williams

workbook level name vs worksheet level name
 
You can use Name Manager (developed by me and JK Pieterse) to filter out
duplicate global/local names, and to convert Global--Local--Global etc
http://www.decisionmodels.com/downloads.htm

Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com

"clara" wrote in message
...
Hi there,

By accident, there are two set of names in my workbook, workbook level and
worksheet level( existing in some worksheets) and the two set are same.
how
can just change the worksheet level names into workbook level names ?

Clara
--
thank you so much for your help





All times are GMT +1. The time now is 04:50 AM.

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