In attachment, I have 6 Sheets. In sheet "Collate", I have linked few cells from other 5 sheets.
For some reason as per my work flow, I need to delete the 5 sheets and create same 5 sheets again.
But as soon as I delete these 5 sheets, the link in Sheet "Collate" Become liks this =#REF!D3. It does not shows any value.
Eben after creating the same sheets with same names the links does get updated.
Can any one help on this?
Is there any code which can link the same cells again to show the value of linked cell.
Bookmarks