Hi all,
I have a sheet where cell, K3 links to A3. When I duplicate the sheet, on the new sheet K3 links back to A3 on the original sheet.
How can I duplicate the sheet but the new K3 links to its own A3 and not to the original sheet?
I know I can manually update the link but I make hundreds of duplicate sheets so that's not really an option
Thanks in advance
I have a sheet where cell, K3 links to A3. When I duplicate the sheet, on the new sheet K3 links back to A3 on the original sheet.
How can I duplicate the sheet but the new K3 links to its own A3 and not to the original sheet?
I know I can manually update the link but I make hundreds of duplicate sheets so that's not really an option
Thanks in advance