Name manager and refrences problem

[hamadsultan]

Hi experts;
I ahve a workbook and i want to copy two sheets from it to new workbook. I copied but the problem is that old sheet have refrences like AMB which is equal to some range of cells. But when i copied data and formulas are paste into new worksheet. But when i press F5 nothing shown in new workbook. How can i copy the refrences name as well?
Second if i try to create a new refrence it shows it already present.
How i fix it?
Regards

 

[jmthompson]

try copying the worksheet instead of the data. Open both workbooks, right click on tab, select move or copy worksheet, choose the destination workbook, select the position within the new workbook and then check create a copy.

 

[hamadsultan]

Hi;
When i right click on the Tab (sheet name) the move or copy is grayed. Not active. Now what can i do?