OK, dumb question here
I have a workbook with multiple sheets. Those sheets are duplicates of the first one (long story but trust me here). Now I want to have all the rest of the sheets reference the first one so have the formula in the others a "=sheet1!a8". But if I delete the cell in the sheet1 the other sheets now have "#REF" in that cell. How can I get the other sheets (not the "master" sheet1) have the reference appropriately to the "master" sheet1?
Thanks
E
Either use Clear Contents rather than Delete. Or, maybe use a lookup function rather than simple cell references. Could be VLOOKUP, INDEX/MATCH, XLOOKUP (if you have it), etc.
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks for sharing your experiences. sometimes I also stuff in this same issue
TryinsteadFormula:
Please Login or Register to view this content.
Also please add your XL version to your profile. Thx
Or you could try:Same effect but non-volatile.Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks