Copying Interlinked Worksheets
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.
-
Hi Peter,
Thanks for reaching out! Unfortunately, there isn't an automated way to accomplish this. The only option is to duplicate both sheets and then update the formulas.
I've created a feature request with our product team for this, and we will keep you updated as it moves forward.
0댓글을 남기려면 로그인하세요.
댓글
댓글 1개