Claire has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Updating contents of one cell based on entry in another
example: I have depth information in cell D7, and additional depth information in cell E7. I want cell D7 to update according to what is entered in E7 (D7 plus E7), and for each entry in the column. I keep getting a circular reference warning when I try simply D7 plus E7. I want to set this sheet up as a template for lots of different jobs. I'm sure this wasn't so difficult in 2003 Excel!
RE: updating contents of one cell based on entry in another
Hi Claire, thanks for your query. Sounds like you are putting =D7+E7 in either of those two referenced cells themselves. That's a no no, I'm afraid. You can't have a cell referencing itself in a formula. The formula will need to go in a third cell to display the result. There is a way round this, but it involves a lot of code!
Hope this helps,
Anthony
