making cells adjust

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

Guest

how do you make cells recalculate when their input cells are changed. eg you
have a cell that is dependent on the value of another. I want this cell to
recalculate automatically when i change the value of the input cell. I also
want to copy this cell along a row and have all the new cells reaclculate too.
Thanks for any help.
 
Cells with formulas should update automatically as long
as XL is set to calculate automatically. Go to Tools >
Options > Calculation tab and check.

HTH
Jason
Atlanta, GA
 
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

Display message while calculating forumlas 3
Excel Typed text appears in wrong cell 0
recalculation not recalculating some cells containing user functio 2
Calculation 4
Hide and Show Rows based on Cell Value 2
Recalculate changes only 2
Which version have smart recalculation engine? 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top