I feel stupid, but I forgot how to auto populate one cell to another cell on another sheet or page to another cell. I know I use the name of the sheet/page and then the cell letter and number. I just forgot the format.
I feel stupid, but I forgot how to auto populate one cell to another cell on another sheet or page to another cell. I know I use the name of the sheet/page and then the cell letter and number. I just forgot the format.
=Sheet1!A1
Or click in the cell where you want the value to appear, type a = sign and then click the other sheet, click the cell you want to display and hit enter.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks