Changing worksheet references
After copying worksheets from one workbook into a new one the cell references
in the new workbook refer to values in the old workbook A typical cell
reference in the new workbook might look like ='C:\Some
Directory\[SomeWorkbook.xlsm]SomeWorksheet'!$AQ$4'. The correct reference in
the new workbook should be =SomeWorksheet!$AQ$4.
There must be several hundred such references in the new workbook. Is there
some way, other than manually, to correct the references to the current
workbook?
TIA,
Ken
|