On Sheet1, select C1 and do Insert > Name > Define Sheet1!relLeft refers to: Sheet1!B1 (no $ signs).
Enter =relLeft in in any cell on Sheet1 and it will return the value of the cell to the left.
On Sheet1, select C1 and do Insert > Name > Define Sheet1!relLeft refers to: Sheet1!B1 (no $ signs).
Enter =relLeft in in any cell on Sheet1 and it will return the value of the cell to the left.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks