Hi,
First off thanks for reading,
My problem is I have a master workbook that line managers put all of their staff information into, up to 12 staff. The sheet workbook uses defined name lists ( as we need to govern/analyse the information), in case the line manager wants to populate the information straight onto it. However there is an individual version that the line manager can ask the person to complete as some staff work remotely, which the LM would then paste it into the master workbook. The individual sheet also contains the same wording but a different define name list so that pasting would not cause an issue.
Pasting works fine once, but once the pasting occurs twice the 'A formula or sheet you want to move or copy contains the name' warning appears. We need to find a solution as the click yes is not one over the volume of LM that are using it.
Many thanks
First off thanks for reading,
My problem is I have a master workbook that line managers put all of their staff information into, up to 12 staff. The sheet workbook uses defined name lists ( as we need to govern/analyse the information), in case the line manager wants to populate the information straight onto it. However there is an individual version that the line manager can ask the person to complete as some staff work remotely, which the LM would then paste it into the master workbook. The individual sheet also contains the same wording but a different define name list so that pasting would not cause an issue.
Pasting works fine once, but once the pasting occurs twice the 'A formula or sheet you want to move or copy contains the name' warning appears. We need to find a solution as the click yes is not one over the volume of LM that are using it.
Many thanks