are you asking for a circular reference?
this can probably be done with a macro, but I don't think it can be
done with a regular spreadsheet formula, but of course, I may be wrong
, so lets see what others think, if you want a macro for it let me know.