trying to copy a worksheet containing named ranges to anotherworksheet

C

cil9mxm

I'm trying to copy a worksheet containing named ranges to another
worksheet w/in the same workbook but it keeps wanting to reference the
name ranges of the first worksheet. Is there anyway to do this
gracefully? I want each copied worksheet to reference it's own named
ranges and all the worksheets need to be w/in the same workbook.

- Mo
 
S

Spiky

I'm trying to copy a worksheet containing named ranges to another
worksheet w/in the same workbook but it keeps wanting to reference the
name ranges of the first worksheet.  Is there anyway to do this
gracefully?  I want each copied worksheet to reference it's own named
ranges and all the worksheets need to be w/in the same workbook.

- Mo
Click to expand...

Copy the Sheet, not the cells. Click-drag the tab while holding down
CTRL to copy the Sheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Limit to Named Ranges 1
How to get range names to Apply across multiple tabs 1
How do I have a cell value define a dynamic named range? 15
Named Ranges and Dynamic Formulas 3
Use named ranges in array formula 14
Copying Named Range 5
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Link to a named range in another worksheet that is sorted frequent 2

Top