Excel: Paste cells from 1 workbook to another, picking up local range names
Posted on 2014-08-14
If I paste a group of cells (about 100 rows x 4 columns) from one workbook to another in Excel 2003. Some of the cells have range names (e.g. "Income") and those range names exist in both workbooks.
How can I do this copy/paste so the pasted range names access the values for those range names in the new workbook range names, rather than picking up the values for those range names in the old workbook?
For example, if the range name "Income" equals 1000 in the old workbook and 1001 in the new workbook. When I paste the cells, which include that range name, all cells refering to the "Income" range name should show 1001 in the new workbook.
If it would be easier to copy the entire sheet from one workbook to another, in such a way as it meets the above requirements, then I'm open to that too. I'm just not sure how to do it so that it meets my requirements.
So far my web searches re this have not been helpful.