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