I have two sheets for example. We will call them Bang and Earlobe.
If on Bang, I have a reference in cell A1 that sets it to be equal to F6 on Earlobe and I change the name of the Earlobe sheet, it dynamically updates.
If I delete the Earlobe sheet, I get a reference, and even if I recreate the Earlobe sheet, it remains a reference on Bang.
How can I maintain the =Earlobe!F6 in cell A1 on Bang regardless of the existence of an Earlobe sheet?
You can't.
If a sheet is deleted, you can't take any information of (the deleted) sheet.
What you could do before delete the sheet.
copy => paste special => value.
Then the reference in A6 will change in the value of that cell.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks