I’m trying to set up a worksheet so that text entered into one cell appears in a cell in another worksheet (same file). I used to know on older programs, but can’t find it. And why does MS help suck so bad :mad: ?
Thanks!
One way is just a straight formula in the form of:
=Sheet1!A1
entered into the cell where you want to show the data. Sheet1 = Sheet Name and A1 = the cell reference.
=Sheet#![Cell]
eg. “=Sheet1!A3” displays the information from A3 on worksheet #1 in whatever cell “=Sheet1!A3” is entered into.
It also works if you rename the worksheet to, say, username_taken:
=username_taken!A1
One way to do it without remembering the format, is to type an equal sign (=) and then navigate to the cell you want to reference and hit [Enter].