Automatically update a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy corresponding cell in Column B if cell in A contains certain text? 1
Automatic Highlighting of Cells 4
Access Automatically Send a notification email once a record is added 0
Enter a number on different cells automatically ? 3
Automatic Data Update by Date Range 1
workng bet wrksheets 2
Auto Change Formulas - Please Help. 2
resettable, over-ridable, default cell values 0

Back
Top