Can you format cells to transfer text automatically?
Posted by Jeff on January 07, 2002 9:50 AM
I've created a monthly workbook with several different report sheets in it. Although I'm still very much a novice with Excel.
What I would like to do is to format different cells on different sheets in this workbook, so that when I type in "Jan. 2002" in the month/year cell on my first sheet report, that it will automatically show up in the month/year cells on all other reports in my monthly workbook.
Although those are different cells on each of these report sheets.
I can do this with numbers, but don't know how to with "text" like the word "January". I've been told that I might could create a link, but I've never done that. Could someone tell me how to do this? I would need instructions for the "simple-minded".