Spreadsheet: 109165d1306108647-dropdown-boxes-not-updating-cells-excel-forum-example
Sheet: Sheet2

DATA VALUES ONLY TO BE ENTERED ON THIS SHEET:
Kids Community | Commencement Date | 2010-07-01 00:00:00
Kids Community | [NAME] | 2012-06-30 00:00:00 |  |  |  |  |  |  |  |  | *DONE
Kids Community | Period From | 2010-07-01 00:00:00 | 2010-10-01 00:00:00 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-01-01 00:00:00
Kids Community | Period To | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-03-31 00:00:00
Kids Community | Invoice Date | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 31/2/2012 | 2012-06-30 00:00:00
Kids Community | Amount excl. GST | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000
Kids Community | Report due Date | 31/9/2010 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-03-31 00:00:00
Kids Community | Report Type | Yearly | Yearly | Yearly | Yearly | Daily | Monthly | Daily | Monthly
[NAME] | Contractor / Representative Name | [NAME]
City Community | Commencement Date | 2011-05-20 00:00:00
City Community | [NAME] | 2012-06-30 00:00:00
City Community | Period From | 2010-07-01 00:00:00 | 2010-07-01 00:00:00 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-01-01 00:00:00
City Community | Period To | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-03-31 00:00:00
City Community | Invoice Date | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 31/2/2012 | 31/2/2012
City Community | Amount excl. GST | 21250 | 21250 | 21250 | 21250 | 21250 | 21250 | 21250 | 21250
City Community | Report due Date | 31/9/2010 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-03-31 00:00:00
City Community | Report Type | Quarterly | Quarterly | Quarterly | Quarterly/Annual | Quarterly | Quarterly | Quarterly | Quarterly/Annual
[NAME] | Contractor / Representative Name
Mission | Commencement Date | 2010-07-01 00:00:00
Mission | [NAME] | 2012-06-30 00:00:00
Mission | Period From | 2010-07-01 00:00:00 | 2010-07-01 00:00:00 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-01-01 00:00:00
Mission | Period To | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-03-31 00:00:00
Mission | Invoice Date | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 31/2/2012 | 31/2/2012
Mission | Amount excl. GST | 21250 | 21250 | 21250 | 21250 | 21250 | 21250 | 21250 | 21250
Mission | Report due Date | 31/9/2010 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-03-31 00:00:00
Mission | Report Type | Quarterly | Quarterly | Quarterly | Quarterly/Annual | Quarterly | Quarterly | Quarterly | Quarterly/Annual
[NAME] | Contractor / Representative Name
Parent-Teacher | Commencement Date | 2010-07-01 00:00:00
Parent-Teacher | [NAME] | 2012-06-30 00:00:00
Parent-Teacher | Period From | 2010-07-01 00:00:00 | 2010-07-01 00:00:00 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-01-01 00:00:00
Parent-Teacher | Period To | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-03-31 00:00:00
Parent-Teacher | Invoice Date | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 31/2/2012 | 31/2/2012
Parent-Teacher | Amount excl. GST | 21250 | 21250 | 21250 | 21250 | 21250 | 21250 | 21250 | 21250
Parent-Teacher | Report due Date | 31/9/2010 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-03-31 00:00:00
Parent-Teacher | Report Type | Quarterly | Quarterly | Quarterly | Quarterly/Annual | Quarterly | Quarterly | Quarterly | Quarterly/Annual
[NAME] | Contractor / Representative Name
Underpriviledged | Commencement Date | 2010-07-01 00:00:00
Underpriviledged | [NAME] | 2012-06-30 00:00:00
Underpriviledged | Period From | 2010-07-01 00:00:00 | 2010-07-01 00:00:00 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-01-01 00:00:00
Underpriviledged | Period To | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-03-31 00:00:00
Underpriviledged | Invoice Date | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 31/2/2012 | 31/2/2012
Underpriviledged | Amount excl. GST | 21250 | 21250 | 21250 | 21250 | 21250 | 21250 | 21250 | 21250
Underpriviledged | Report due Date | 31/9/2010 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-03-31 00:00:00
Underpriviledged | Report Type | Quarterly | Quarterly | Quarterly | Quarterly/Annual | Quarterly | Quarterly | Quarterly | Quarterly/Annual
[NAME] | Contractor / Representative Name
Skatepark South | Commencement Date | 2010-07-01 00:00:00
Skatepark South | [NAME] | 2012-06-30 00:00:00
Skatepark South | Period From | 2010-07-01 00:00:00 | 2010-07-01 00:00:00 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-01-01 00:00:00
Skatepark South | Period To | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-03-31 00:00:00
Skatepark South | Invoice Date | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 31/2/2012 | 31/2/2012
Skatepark South | Amount excl. GST | 21250 | 21250 | 21250 | 21250 | 21250 | 21250 | 21250 | 21250
Skatepark South | Report due Date | 31/9/2010 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-03-31 00:00:00
Skatepark South | Report Type | Quarterly | Quarterly | Quarterly | Quarterly/Annual | Quarterly | Quarterly | Quarterly | Quarterly/Annual
[NAME] | Contractor / Representative Name
Historical Trust | Commencement Date | 2010-07-01 00:00:00
Historical Trust | [NAME] | 2012-06-30 00:00:00
Historical Trust | Period From | 2010-07-01 00:00:00 | 2010-07-01 00:00:00 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-01-01 00:00:00
Historical Trust | Period To | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-03-31 00:00:00
Historical Trust | Invoice Date | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 31/2/2012 | 31/2/2012
Historical Trust | Amount excl. GST | 21250 | 21250 | 21250 | 21250 | 21250 | 21250 | 21250 | 21250
Historical Trust | Report due Date | 31/9/2010 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-03-31 00:00:00
Historical Trust | Report Type | Quarterly | Quarterly | Quarterly | Quarterly/Annual | Quarterly | Quarterly | Quarterly | Quarterly/Annual
[NAME] | Contractor / Representative Name