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
<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>
</TBODY>
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
DATE | PURCHASE ORDER | PRODUCTIVE HOURS against PO | HOURS USED | HOURS REMAINING |
30-Aug-12 | abc | 2000 | 2000 | |
01-Sep-12 | 490 | 1510 | ||
15-Sep-12 | 190 | 1320 | ||
22-Sep-12 | 600 | 720 | ||
02-Oct-12 | 550 | 170 | ||
11-Oct-12 | xyz | 3000 | 3170 | |
15-Oct-12 | 200 | 2970 | ||
26-Oct-12 | 270 | 2700 | ||
01-Nov-12 | 500 | 2200 |
<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>
</TBODY>