I have a multi-tabbed sheet that summarizes based on with locally defined name ranges in the tabs. I need to add new defined names and REALLY hope there's a way to copy the local name definitions to the the sheets. I can't seem to find anything. While I could update one tab with the defined names and copy that tab, it would require back entering data of the old tab onto the new copy. I suspect it will take about as long to recreate all the tabs as it will to manually create the names, but ugggggg...