I have several workbooks/files that are set up the same, with cells in one worksheet linked to several other worksheets within the workbook/file.
I would like to copy the links from one workbook/file to another, but have the formulas that I copy refer to the worksheets within the new workbook that I am copying it to.
Is there any easy way, other than changing the referenced workbook in each cell?
Please help!!
Thanks!
I would like to copy the links from one workbook/file to another, but have the formulas that I copy refer to the worksheets within the new workbook that I am copying it to.
Is there any easy way, other than changing the referenced workbook in each cell?
Please help!!
Thanks!