I worked on an excel sheet (1st) which has a lot of "defined Range"
When I duplicate that excel sheet to make to 2nd sheet, I went to Formula -> then Name Manager -> Edit the name of these "defined Range" to differentiate them with which has been defined in the 1st excel sheet
I can see these "defined Range" in the Name Manager of that 2nd sheet but when I move to a different sheet and need to paste the "defined Range" of the 2nd sheet, I could not find them
Is this an error of Excel and is there any other way than I need to defined range all over again (which is super super time-consuming)
Thanks in advance, really appreciate if someone could help me out