Hi,

I have two identical spreadsheets, except one has an additional sheet, with
links to cells and ranges within the sheets in that workbook.

I've populated the sheets within the workbook without the additional sheet
(don't ask why!), now find I need that sheet. However, when I copy it
across, it retains its links to the referenced sheets within its own
workbook.

How can I copy this sheet across to the other workbook, have it retain its
references (formulas), but within the new workbook? I.E. I want it pointing
to the same cells/ranges, but from the new workbook, not the one from which
it has just been copied.

Hope this make sense?

All help appreciated.

Thanks.