Hi,
I have a sheet that I need to copy dozens of times. This sheet (let's call it MasterSheet) has named ranges that are not for the entire workbook but only for itself in order to succefully reproduce the Mastersheet: I named for example "StartPause1" the cell B4, so that from now on each sheet has a specific "StartPause1" that refers to its B4.
I have also DataSheet where the orders are listed. I have in MasterSheet a dropdown list referereing to the range name "Orderlist" (this one is for the entire workbook). My problem is that when I copy the sheet, it creates a local "Orderlist" in the MasterSheet and the new sheet. Anyway to avoid that?
Thanks in advance for your help
I have a sheet that I need to copy dozens of times. This sheet (let's call it MasterSheet) has named ranges that are not for the entire workbook but only for itself in order to succefully reproduce the Mastersheet: I named for example "StartPause1" the cell B4, so that from now on each sheet has a specific "StartPause1" that refers to its B4.
I have also DataSheet where the orders are listed. I have in MasterSheet a dropdown list referereing to the range name "Orderlist" (this one is for the entire workbook). My problem is that when I copy the sheet, it creates a local "Orderlist" in the MasterSheet and the new sheet. Anyway to avoid that?
Thanks in advance for your help
Last edited: