Geoffrey1231
New Member
- Joined
- Oct 28, 2005
- Messages
- 22
Hi there,
I have a two-part question;
How would I extend a formula automatically. Anotherwords, the formula sums say E5:E10. What I want to do is make sure that whenever a new record is created below E10 that the formula extends to include that cell. So if a number was placed in E20, then the formula would be the sum of E5:E20.
The second part of my question is how to handle the same type of issue but for extending an "If" statement and a drop down list when a new record is added. So if I start typing in the first cell of the next row, then the lists and "If" statements should carry down to that row.
Hope you can help,
Geoff
I have a two-part question;
How would I extend a formula automatically. Anotherwords, the formula sums say E5:E10. What I want to do is make sure that whenever a new record is created below E10 that the formula extends to include that cell. So if a number was placed in E20, then the formula would be the sum of E5:E20.
The second part of my question is how to handle the same type of issue but for extending an "If" statement and a drop down list when a new record is added. So if I start typing in the first cell of the next row, then the lists and "If" statements should carry down to that row.
Hope you can help,
Geoff