excel named range copy from sheet to sheet

excel named-ranges
rekordboy picture rekordboy · Apr 5, 2013 · Viewed 34.2k times · Source

I have an Excel question, I am wondering if there is an easy way to set up a clone or copy of a named range in one worksheet to another worksheet in the same workbook. I need this to be done automatically as the data comes in through a third party software tool. I am not an advanced excel user and was hoping there would be a simple way to do this without macros, vba code etc. Any thoughts? Thanks!

Answer

wilsjd picture wilsjd · Apr 5, 2013

You can set the scope of the source named range to just the sheet, then copy the sheet. The named ranges will be copied as well.

To change the scope, use the Name Manager in Data section of the ribbon, or push Ctrl + F3. Select the Range and click edit.

enter image description here

To copy the sheet, right click on the sheet name and select "Move or Copy"

enter image description here

Related questions

How do I reference a cell within excel named range?

For example, I have a named range A10—A20 as Age; how do I get Age[5] which is same as A14. I can write "=A14" but I did like to write "=Age$5" or something similar.

Read More
VBA- Find location of first cell in named range to reference heading row of spreadsheet

What I have is part descriptions that I have split into separate columns. All columns have headings, but not all columns contain information for every part, ex: some might have size, material, and temp while another may have just size …

Read More
Referencing Dynamic Named Range in Excel Formula

I have a table in Excel with column headings that correspond to part of a dynamic named range elsewhere in my workbook. For example, I have these column headings: "10", "20", etc., and these dynamic named ranges: "ExampleRange10", "ExampleRange2", etc. I'd like …

Read More