Forum home » Delegate support and help forum » Microsoft Excel Training and help » Updating contents of one cell based on entry in another
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Updating contents of one cell based on entry in another
Resolved · Medium Priority · Version 2010
Reply Thu 16 Sep 2010, 11:48Delegate Claire said...
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!
For upcoming training course dates see: Pricing & availability
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
Tue 28 Sep 2010: Automatically marked as resolved.
|