Hi,
Can you share your workbook with us? If so manually add the results you expect to see on the Calculations sheet so we can be cleaar as to exactly what you want
1. Are you expecting to see as many rows in the Residential Calculations sheet as there are in the Inputs sheet?
2. Are you adding new blocks of data below the existing data?
3. Is there a particular reason why you want a second sheet with just a single formula when you could just add another column to the Inputs sheet which gets updated automatically as you add new data.
4. Is it really a single formula on the Calculations sheet or a formula that is copied down all the rows (see 1 above)
One way would be the Sheet Calculations sheet Activate event.
Something like
Bookmarks