Excel question:
HOW, do I get text from one cell on one sheet to show in another cell on another sheet, easy with numbers but no luck with words, trying all sorts none of it is working.
ie. if I type "january" into a cell on sheet 2, I want the word "january" to appear in another cell on sheet 1
Anyone, Bueller?
If your original cell contains 'January', the easiest way is to do this is to type "=" in the new cell, then click the sheet containing the original cell, then select the original cell itself by clicking it, then hit enter. This enters a formula into the 2nd cell telling it to just repeat whatever is in the original cell, whether it is text or numbers.
Note that if you update the original cell, this change will also happen to the new, linked cell.
If your original cell contains 'January', the easiest way is to do this is to type "=" in the new cell, then click the sheet containing the original cell, then select the original cell itself by clicking it, then hit enter. This enters a formula into the 2nd cell telling it to just repeat whatever is in the original cell, whether it is text or numbers.
Note that if you update the original cell, this change will also happen to the new, linked cell.