tx guys. So I'm trying to have a cell read the value of a cell even if it is moved and/or replaced and wondering if it's possible.
i.e.: a1 has an "8" in it. a2 has a "2" in it. b1 reads "=a1" so then displays an "8" but if I cut a1 and paste it in a3 and move a2 up into a1, then b1 now reads the "8" in a2 instead of the "2" a1. Anyway to keep b1 reading the "CELL" of a1 and not the "Value"?
tx! newbie.
Bookmarks