sheet in the same workbook? Whats the formula/function called ?
I know it can be done but it has been three yrs since I have done it and it really bugs me that I dont remember.
I have tried the first two advice already and it just displays the cell reference.... maybe I need to toggle out of this display mode?
Accountant
Favorite Answer
Go to the second Cell where you want the text to appear and hit equal sign ( = ) then move your cursor to the first cell where you already have the original text click on that cell and then hit enter.
Tip: Do not click on anything else once you choose the source cell just hit enter!
Always feel free to ask any excel questions! send email
Promethean Geek
Go to the sheet with the target cell where you want the value to appear.
Click on the target cell
Hit the equal '=' key
Go to the sheet where the source cell is.
Click on the source cell.
Hit 'Enter'
Daniel R.
in the 2nd worksheet, place your cursor where you want the text to begin.
Hit the shift and then the + key at the same time and bring your cursor to the original text in the first worksheet and hit enter. Easy as that.