Thanks guys for the input, but I figured it out. I knew how to do the = and
enter scenario, but what I did do was the information I wanted to
automatically input in other worksheets in various areas was copy then paste
special, and linked the cells.

Thanks though!

"nbrcrunch" wrote:


Tess,

Though the above poster's reply would work, from what I read, it seems
overkill for what you are asking.

First, I'd recommend you pick up a beginner's book on Excel, because,
as I read your post, you are asking a question that is Excel101, no
insult intended.

To illustrate,

1. In the first place on a different sheet that you want a value read
from your input sheet, type an equals sign.

2. Now click the tab and then click the cell that contains the source
input.

3. Press your Enter key.

Now, whatever value you enter on your input sheet is immediately echoed
to your calculations sheet.


--
nbrcrunch