#1
|
|||
|
|||
Trying to link a cell from one worksheet to another
I click on cell in worksheet and type =up in the formula bar, then I highlight the cell in the worksheet I want to link from , hit enter, and the formula ='2018'!I69 appears in the cell instead of the number. Why is the formula appearing in the cell and not the number |
#2
|
|||
|
|||
The cell is formatted as text!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how do i use a named cell for each worksheet | cwkotch | Excel | 3 | 11-03-2015 09:04 AM |
link worksheet on shared file | hifrank | Word | 0 | 06-24-2015 07:29 AM |
Worksheet defined cell sums | flextera | Excel | 3 | 06-17-2014 11:12 AM |
getting the worksheet name in a cell | derohanes | Excel | 9 | 02-14-2013 01:29 PM |
click a cell to go to a worksheet | victor | Excel | 0 | 10-27-2006 02:57 PM |