You can "pull" the information from one cell to another with a formula like:

=if('sheet1'!="","",'sheet1'!a1)

If you have a table of values and want to return a value from a cell on the same
row, you could use =vlookup() or =index(match()).

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

clayblay wrote:

I've got a new question. What is the formula for changing information in one
field on a worksheet and update that same informationin the appropriate field
on another worksheet?

"Dave Peterson" wrote:

If you put 16 in A1,
you can put this in B1: =int(a1/3)
you can put this in C1: =b1
you can put this in D1: =a1-b1-c1




clayblay wrote:

In MS Excel I would like to show a quotient in three separate columns such as
16/3 = 5 + 5 + 6. Can this be done? Please let me know a.s.a.p.

--

Dave Peterson


--

Dave Peterson