copying defined names

[mmcksmith]

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...

[maitrayk]

Hi mmcksmith,

You can use below code to copy named ranges to new sheet

Please Login or Register  to view this content.

[mmcksmith]

thank you! Not up on my VBA, so going with manual today, but will poke at it later this week when things clear up. If you're willing, could you headstart me to copy from tab "original" to tab "copy"?