MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to calculate formula automatically


Posted by Ian Cherng on September 08, 2001 5:06 AM

I want the formula in sheet2 to auto-calculate after I type-in a value in sheet1, without using the 'drag and fill formula' in sheet2, How can I do this, Please send me an excel example, Thanks


Posted by Keith on September 10, 2001 4:29 AM

Hello Ian,

All you have to do is link the cell with the formula on page two to the data on page 1. Here's a simple rounding example, which you can paste into any cell in sheet 2 (or whatever sheet) calling data from sheet 1, cell A1:

=ROUND(Sheet1!$A$1,0)

The format is to put in the sheet name with an "!" after the name, then the cell address--in this case A1.

Hope this helps...

~Keith