98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Updating contents of one cell based on entry in another
Updating contents of one cell based on entry in another
Resolved · Medium Priority · Version 2010
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!
Mon 20 Sep 2010, 07:07Trainer Anthony said...
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.
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. |
Excel tip:Make a quick copy of a worksheetHold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too. |
