I have a spreadsheet where I need the end result to be auto filled after recognition of an adhoc "top up" amount.
How do I get E7 (3170) to automatically recognise the insertion of C7 (3000) to give this result without having to manually update the formula in E7?
Thank you,
Regards, Pete
[TABLE="width: 342"]
<COLGROUP><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2496" width=78><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2432" width=76><COL style="WIDTH: 97pt; mso-width-source: userset; mso-width-alt: 4128" width=129><COL style="WIDTH: 69pt; mso-width-source: userset; mso-width-alt: 2944" width=92><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 2560" width=80><TBODY>[TR]
[TD="class: xl27, width: 78, bgcolor: #ffff99"]DATE[/TD]
[TD="class: xl24, width: 76, bgcolor: #ffff99"]PURCHASE
ORDER[/TD]
[TD="class: xl24, width: 129, bgcolor: #ffff99"]PRODUCTIVE
HOURS against PO[/TD]
[TD="class: xl24, width: 92, bgcolor: #ffff99"]HOURS USED[/TD]
[TD="class: xl24, width: 80, bgcolor: #ffff99"]HOURS
REMAINING[/TD]
[/TR]
[TR]
[TD="class: xl25, bgcolor: transparent"]30-Aug-12[/TD]
[TD="class: xl26, bgcolor: transparent"]abc[/TD]
[TD="class: xl26, bgcolor: transparent"]2000[/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"]2000[/TD]
[/TR]
[TR]
[TD="class: xl25, bgcolor: transparent"]01-Sep-12[/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"]490[/TD]
[TD="class: xl26, bgcolor: transparent"]1510[/TD]
[/TR]
[TR]
[TD="class: xl25, bgcolor: transparent"]15-Sep-12[/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"]190[/TD]
[TD="class: xl26, bgcolor: transparent"]1320[/TD]
[/TR]
[TR]
[TD="class: xl25, bgcolor: transparent"]22-Sep-12[/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"]600[/TD]
[TD="class: xl26, bgcolor: transparent"]720[/TD]
[/TR]
[TR]
[TD="class: xl25, bgcolor: transparent"]02-Oct-12[/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"]550[/TD]
[TD="class: xl26, bgcolor: transparent"]170[/TD]
[/TR]
[TR]
[TD="class: xl25, bgcolor: transparent"]11-Oct-12[/TD]
[TD="class: xl26, bgcolor: transparent"]xyz[/TD]
[TD="class: xl26, bgcolor: transparent"]3000[/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"]3170[/TD]
[/TR]
[TR]
[TD="class: xl25, bgcolor: transparent"]15-Oct-12[/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"]200[/TD]
[TD="class: xl26, bgcolor: transparent"]2970[/TD]
[/TR]
[TR]
[TD="class: xl25, bgcolor: transparent"]26-Oct-12[/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"]270[/TD]
[TD="class: xl26, bgcolor: transparent"]2700[/TD]
[/TR]
[TR]
[TD="class: xl25, bgcolor: transparent"]01-Nov-12[/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"]500[/TD]
[TD="class: xl26, bgcolor: transparent"]2200[/TD]
[/TR]
</TBODY>[/TABLE]
How do I get E7 (3170) to automatically recognise the insertion of C7 (3000) to give this result without having to manually update the formula in E7?
Thank you,
Regards, Pete
[TABLE="width: 342"]
<COLGROUP><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2496" width=78><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2432" width=76><COL style="WIDTH: 97pt; mso-width-source: userset; mso-width-alt: 4128" width=129><COL style="WIDTH: 69pt; mso-width-source: userset; mso-width-alt: 2944" width=92><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 2560" width=80><TBODY>[TR]
[TD="class: xl27, width: 78, bgcolor: #ffff99"]DATE[/TD]
[TD="class: xl24, width: 76, bgcolor: #ffff99"]PURCHASE
ORDER[/TD]
[TD="class: xl24, width: 129, bgcolor: #ffff99"]PRODUCTIVE
HOURS against PO[/TD]
[TD="class: xl24, width: 92, bgcolor: #ffff99"]HOURS USED[/TD]
[TD="class: xl24, width: 80, bgcolor: #ffff99"]HOURS
REMAINING[/TD]
[/TR]
[TR]
[TD="class: xl25, bgcolor: transparent"]30-Aug-12[/TD]
[TD="class: xl26, bgcolor: transparent"]abc[/TD]
[TD="class: xl26, bgcolor: transparent"]2000[/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"]2000[/TD]
[/TR]
[TR]
[TD="class: xl25, bgcolor: transparent"]01-Sep-12[/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"]490[/TD]
[TD="class: xl26, bgcolor: transparent"]1510[/TD]
[/TR]
[TR]
[TD="class: xl25, bgcolor: transparent"]15-Sep-12[/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"]190[/TD]
[TD="class: xl26, bgcolor: transparent"]1320[/TD]
[/TR]
[TR]
[TD="class: xl25, bgcolor: transparent"]22-Sep-12[/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"]600[/TD]
[TD="class: xl26, bgcolor: transparent"]720[/TD]
[/TR]
[TR]
[TD="class: xl25, bgcolor: transparent"]02-Oct-12[/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"]550[/TD]
[TD="class: xl26, bgcolor: transparent"]170[/TD]
[/TR]
[TR]
[TD="class: xl25, bgcolor: transparent"]11-Oct-12[/TD]
[TD="class: xl26, bgcolor: transparent"]xyz[/TD]
[TD="class: xl26, bgcolor: transparent"]3000[/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"]3170[/TD]
[/TR]
[TR]
[TD="class: xl25, bgcolor: transparent"]15-Oct-12[/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"]200[/TD]
[TD="class: xl26, bgcolor: transparent"]2970[/TD]
[/TR]
[TR]
[TD="class: xl25, bgcolor: transparent"]26-Oct-12[/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"]270[/TD]
[TD="class: xl26, bgcolor: transparent"]2700[/TD]
[/TR]
[TR]
[TD="class: xl25, bgcolor: transparent"]01-Nov-12[/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"] [/TD]
[TD="class: xl26, bgcolor: transparent"]500[/TD]
[TD="class: xl26, bgcolor: transparent"]2200[/TD]
[/TR]
</TBODY>[/TABLE]