My workbook contains a pair of worksheets, SheetA and SheetB.
SheetA contains formulae that link to SheetB.
I would like to duplicate both Sheet A & B to create Sheets C and D), and I would like the formulae to point at the new worksheets (Sheet C linking to Sheet D).
Is it possible to do this?
When I try the standard 'select worksheets, right click, duplicate' option, the links in the new worksheet, SheetC, all point to the original source worksheet, SheetB.