Excel 2007
I have a workbook with seven sheets that are all updated weekly. I've created an extra sheet that references data on all seven of the orignal sheets with the goal being to keep this new sheet completely self contained so it can be easily copy/pasted each week to the updated workbook.
My problem is when I copy/paste the sheet, only four of the named ranges copy over to the new workbook. Here's a pic of all the named ranges I need to be copied over. The yellow lines point to the named ranges that copy fine, all the other named ranges do not copy over.
Suggestions?
Ted.
I have a workbook with seven sheets that are all updated weekly. I've created an extra sheet that references data on all seven of the orignal sheets with the goal being to keep this new sheet completely self contained so it can be easily copy/pasted each week to the updated workbook.
My problem is when I copy/paste the sheet, only four of the named ranges copy over to the new workbook. Here's a pic of all the named ranges I need to be copied over. The yellow lines point to the named ranges that copy fine, all the other named ranges do not copy over.
Suggestions?
Ted.
