I have a form with a few different cells that users enter numbers and other
info. Right after they enter these numbers this info should automatically be
entered into the next page (same sheet) into other cells with same label
info. How can you automatically update other cells based on the contents of
the upper cells, what is the function? Do I need a macro for this or do it
in VBA coding?

It seems to me that if you have Calculations set to Automatic, then that
should happen. Check under Tools-Options-Calculation. Set to Automatic.

HTH,
Paul

"Adriana" wrote in message
...
I have a form with a few different cells that users enter numbers and other
info. Right after they enter these numbers this info should automatically
be
entered into the next page (same sheet) into other cells with same label
info. How can you automatically update other cells based on the contents
of
the upper cells, what is the function? Do I need a macro for this or do
it
in VBA coding?

In the cell(say A56) to be updated have a linked formula like

=A1

When A1 changes then A56 will also change.


Gord Dibben MS Excel MVP

On Thu, 7 Jun 2007 13:16:01 -0700, Adriana
wrote:

I have a form with a few different cells that users enter numbers and other
info. Right after they enter these numbers this info should automatically be
entered into the next page (same sheet) into other cells with same label
info. How can you automatically update other cells based on the contents of
the upper cells, what is the function? Do I need a macro for this or do it
in VBA coding?