Spreadsheet: 116077d1311591204-information-from-one-spreadsheet-to-another-automatically-spreedsheet-for-forum-result
Sheet: Tracker

Test Spreadsheet
Month | Site Name | Reference 2 | Area | Start Date | Completion Date | Extra Field I would add | Extra Field I would add | Extra Field I would add
June | Project Number1 | ABC/A11/Y1/C001 | 4 | 2011-05-26 00:00:00 | 2011-06-02 00:00:00
June | Project Number2 | ABC/A11/Y1/C002 | 4 | 2011-06-02 00:00:00 | 2011-06-06 00:00:00
June | Project Number3 | ABC/A11/Y1/C003 | 12 | 2011-05-16 00:00:00 | 2011-06-08 00:00:00
June | Project Number4 | ABC/A11/Y1/C004 | 12 | 2011-05-31 00:00:00 | 2011-06-10 00:00:00
June | Project Number5 | ABC/A11/Y1/C005 | 4 | 2011-06-08 00:00:00 | 2011-06-13 00:00:00
June | Project Number6 | ABC/A11/Y1/C006 | 4 | 2011-06-13 00:00:00 | 2011-06-13 00:00:00
June | Project Number7 | ABC/A11/Y1/C007 | 4 | 2011-06-13 00:00:00 | 2011-06-15 00:00:00
June | Project Number8 | ABC/A11/Y1/C008 | 9 | 2011-06-15 00:00:00 | 2011-06-15 00:00:00
June | Project Number9 | ABC/A11/Y1/C009 | 4 | 2011-06-14 00:00:00 | 2011-06-16 00:00:00
June | Project Number10 | ABC/A11/Y1/C010 | 4 | 2011-06-14 00:00:00 | 2011-06-20 00:00:00
June | Project Number11 | ABC/A11/Y1/C011 | 4 | 2011-06-14 00:00:00 | 2011-06-20 00:00:00
June | Project Number12 | ABC/A11/Y1/C012 | 4 | 2011-06-16 00:00:00 | 2011-06-22 00:00:00
June | Project Number13 | ABC/A11/Y1/C013 | 4 | 2011-06-17 00:00:00 | 2011-06-23 00:00:00
June | [NAME] | ABC/A11/Y1/C014 | 4 | 2011-06-20 00:00:00 | 2011-06-23 00:00:00
June | Project Number15 | ABC/A11/Y1/C015 | 4 | 2011-06-27 00:00:00 | 2011-06-28 00:00:00
June | Project Number16 | ABC/A11/Y1/C016 | 5 | 2011-05-31 00:00:00 | 2011-06-01 00:00:00
June | Project Number17 | ABC/A11/Y1/C017 | 5 | 2011-06-01 00:00:00 | 02/06/0211
June | Project Number18 | ABC/A11/Y1/C018 | 1 | 2011-06-07 00:00:00 | 2011-06-11 00:00:00
June | [NAME] | ABC/A11/Y1/C019 | 1 | 2011-06-07 00:00:00 | 2011-06-11 00:00:00
June | Project Number20 | ABC/A11/Y1/C020 | 1 | 2011-06-13 00:00:00 | 2011-06-14 00:00:00
June | Project Number21 | ABC/A11/Y1/C021 | 1 | 2011-06-13 00:00:00 | 2011-06-14 00:00:00
June | [NAME] | ABC/A11/Y1/C022 | 1 | 2011-06-15 00:00:00 | 2011-06-17 00:00:00
June | [NAME] | ABC/A11/Y1/C023 | 1 | 2011-06-17 00:00:00 | 2011-06-25 00:00:00
June | Project Number24 | ABC/A11/Y1/C024 | 1 | 2011-06-17 00:00:00 | 2011-06-25 00:00:00
June | [NAME] | ABC/A11/Y1/C025 | 1 | 2011-06-17 00:00:00 | 2011-06-25 00:00:00
June | Project Number26 | ABC/A11/Y1/C026 | 1 | 2011-06-18 00:00:00 | 2011-06-18 00:00:00
June | Project Number27 | ABC/A11/Y1/C027 | 1 | 2011-06-19 00:00:00 | 2011-06-23 00:00:00
June | [NAME] | ABC/A11/Y1/C028 | 1 | 2011-06-19 00:00:00 | 2011-06-23 00:00:00
June | Project Number29 | ABC/A11/Y1/C029 | 1 | 2011-06-20 00:00:00 | 2011-06-24 00:00:00
June | Project Number30 | ABC/A11/Y1/C030 | 1 | 2011-06-27 00:00:00 | 2011-06-28 00:00:00
June | Project Number31 | ABC/A11/Y1/C031 | 1 | 2011-06-28 00:00:00 | 2011-06-29 00:00:00
July | [NAME] | ABC/A11/Y1/C032 | 1 | 2011-06-27 00:00:00 | 2011-07-01 00:00:00
July | Project Number33 | ABC/A11/Y1/C033 | 5 | 2011-07-04 00:00:00 | 2011-07-07 00:00:00
July | [NAME] | ABC/A11/Y1/C034 | 5 | 2011-07-12 00:00:00 | 2011-07-14 00:00:00
July | Project Number35 | ABC/A11/Y1/C035 | 5 | 2011-07-12 00:00:00 | 2011-07-14 00:00:00
July | Project Number36 | ABC/A11/Y1/C036 | 5 | 2011-07-07 00:00:00 | 2011-07-08 00:00:00
July | Project Number37 | ABC/A11/Y1/C037 | 5 | 2011-07-07 00:00:00 | 2011-07-08 00:00:00
July | [NAME] | ABC/A11/Y1/C038 | 5 | 2011-07-07 00:00:00 | 2011-07-08 00:00:00
July | Project Number39 | ABC/A11/Y1/C039 | 5 | 2011-07-10 00:00:00 | 2011-07-11 00:00:00
July | Project Number40 | ABC/A11/Y1/C040 | 1 | 2011-07-18 00:00:00 | 2011-07-22 00:00:00
July | Project Number41 | ABC/A11/Y1/C041 | 5 | 2011-07-18 00:00:00 | 2011-07-19 00:00:00
July | Project Number42 | ABC/A11/Y1/C042 | 5 | 2011-07-19 00:00:00 | 2011-07-20 00:00:00
July | Project Number43 | ABC/A11/Y1/C043 | 5 | 2011-07-21 00:00:00 | 2011-07-23 00:00:00
July | Project Number44 | ABC/A11/Y1/C044 | 5 | 2011-07-21 00:00:00 | 2011-07-23 00:00:00
July | [NAME] | ABC/A11/Y1/C045 | 5 | 2011-07-25 00:00:00 | 2011-07-29 00:00:00
July | Project Number46 | ABC/A11/Y1/C046 | 5 | 2011-07-27 00:00:00 | 2011-07-29 00:00:00
July | [NAME] | ABC/A11/Y1/C047 | 1 | 2011-07-25 00:00:00 | 2011-07-27 00:00:00
July | Project Number48 | ABC/A11/Y1/C048 | 5 | 2011-07-25 00:00:00 | 2011-07-29 00:00:00
July | Project Number49 | ABC/A11/Y1/C049 | 5 | 2011-07-25 00:00:00 | 2011-07-29 00:00:00
July | Project Number50 | ABC/A11/Y1/C050 | 5 | 2011-07-25 00:00:00 | 2011-07-29 00:00:00
July | Project Number51 | ABC/A11/Y1/C051 | 5 | 2011-07-25 00:00:00 | 2011-07-29 00:00:00
July | Project Number52 | ABC/A11/Y1/C052 | 1 | 2011-07-25 00:00:00 | 2011-07-27 00:00:00
July | Project Number53 | ABC/A11/Y1/C053 | 1 | 2011-07-26 00:00:00 | 2011-07-28 00:00:00
July | Project Number54 | ABC/A11/Y1/C054 | 1 | 2011-07-27 00:00:00 | 2011-07-29 00:00:00
July | Project Number55 | ABC/A11/Y1/C055 | 1 | 2011-07-27 00:00:00 | 2011-07-29 00:00:00
July | [NAME] | ABC/A11/Y1/C056 | 1 | 2011-07-28 00:00:00 | 2011-07-29 00:00:00
July | Project Number57 | ABC/A11/Y1/C057 | 3 | 2011-06-27 00:00:00 | 2011-07-01 00:00:00
July | [NAME] | ABC/A11/Y1/C058 | 4 | 2011-06-28 00:00:00 | 2011-07-01 00:00:00
July | Project Number59 | ABC/A11/Y1/C059 | 4 | 2011-06-27 00:00:00 | 2011-07-04 00:00:00
July | Project Number60 | ABC/A11/Y1/C060 | 4 | 2011-06-27 00:00:00 | 2011-07-04 00:00:00
July | Project Number61 | ABC/A11/Y1/C061 | 4 | 2011-06-27 00:00:00 | 2011-07-04 00:00:00
July | Project Number62 | ABC/A11/Y1/C062 | 4 | 2011-06-27 00:00:00 | 2011-07-01 00:00:00
July | Project Number63 | ABC/A11/Y1/C063 | 4 | 2011-07-06 00:00:00 | 2011-07-08 00:00:00
July | Project Number64 | ABC/A11/Y1/C064 | 4 | 2011-07-04 00:00:00 | 2011-07-08 00:00:00
July | Project Number65 | ABC/A11/Y1/C065 | 4 | 2011-07-12 00:00:00 | 2011-07-15 00:00:00
July | [NAME] | ABC/A11/Y1/C066 | 2 | 2011-07-11 00:00:00 | 2011-07-15 00:00:00
July | Project Number67 | ABC/A11/Y1/C067 | 2 | 2011-07-11 00:00:00 | 2011-07-15 00:00:00
July | Project Number68 | ABC/A11/Y1/C068 | 2 | 2011-07-11 00:00:00 | 2011-07-15 00:00:00
July | Project Number69 | ABC/A11/Y1/C069 | 2 | 2011-07-11 00:00:00 | 2011-07-15 00:00:00
July | Project Number70 | ABC/A11/Y1/C070 | 2 | 2011-07-11 00:00:00 | 2011-07-15 00:00:00
July | Project Number71 | ABC/A11/Y1/C071 | 2 | 2011-07-11 00:00:00 | 2011-07-15 00:00:00
July | Project Number72 | ABC/A11/Y1/C072 | 2 | 2011-07-13 00:00:00 | 2011-07-15 00:00:00
July | [NAME] | ABC/A11/Y1/C073 | 2 | 2012-07-11 00:00:00 | 2011-07-25 00:00:00
July | Project Number74 | ABC/A11/Y1/C074 | 2 | 2012-07-11 00:00:00 | 2011-07-25 00:00:00
July | [NAME] | ABC/A11/Y1/C075 | 2 | 2012-07-11 00:00:00 | 2012-07-11 00:00:00
July | [NAME] | ABC/A11/Y1/C076 | 2 | 2011-07-18 00:00:00 | 2011-07-19 00:00:00
July | Project Number77 | ABC/A11/Y1/C077 | 2 | 2011-07-18 00:00:00 | 2011-07-19 00:00:00
July | Project Number78 | ABC/A11/Y1/C078 | 2 | 2011-07-20 00:00:00 | 2011-07-22 00:00:00
July | Project Number79 | ABC/A11/Y1/C079 | 2 | 25/007/11 | 2011-07-28 00:00:00
July | [NAME] | ABC/A11/Y1/C080 | 2 | 2011-07-28 00:00:00 | 2011-07-29 00:00:00
July | [NAME] | ABC/A11/Y1/C081 | 2 | 2011-07-13 00:00:00 | 2011-07-19 00:00:00
July | [NAME] | ABC/A11/Y1/C082 | 2 | 2011-07-18 00:00:00 | 2011-07-25 00:00:00
July | [NAME] | ABC/A11/Y1/C083 | 2 | 2011-07-25 00:00:00 | 2011-07-28 00:00:00
July | Project Number84 | ABC/A11/Y1/C084 | 2 | 2011-07-25 00:00:00 | 2011-07-28 00:00:00
July | Project Number85 | ABC/A11/Y1/C085 | 2 | 2011-07-18 00:00:00 | 2011-07-22 00:00:00
July | Project Number86 | ABC/A11/Y1/C086 | 2 | 2011-07-25 00:00:00 | 2011-08-05 00:00:00
August | [NAME] | ABC/A11/Y1/C087 | 5 | 2011-08-01 00:00:00 | 2011-08-03 00:00:00
August | Project Number88 | ABC/A11/Y1/C088 | 5 | 2011-08-01 00:00:00 | 2011-08-03 00:00:00
August | Project Number89 | ABC/A11/Y1/C089 | 5 | 2011-08-01 00:00:00 | 2011-08-03 00:00:00
August | Project Number90 | ABC/A11/Y1/C090 | 2 | 2011-07-25 00:00:00 | 2011-08-01 00:00:00
August | [NAME] | ABC/A11/Y1/C091 | 2 | 2011-07-25 00:00:00 | 2011-08-01 00:00:00
August | [NAME] | ABC/A11/Y1/C092 | 2 | 2011-08-01 00:00:00 | 2011-08-05 00:00:00
August | [NAME] | ABC/A11/Y1/C093 | 2 | 2011-08-01 00:00:00 | 2011-08-02 00:00:00
August | Project Number94 | ABC/A11/Y1/C094 | 2 | 2011-08-01 00:00:00 | 2011-08-05 00:00:00
August | Project Number95 | ABC/A11/Y1/C095 | 2 | 2011-08-01 00:00:00 | 2011-08-01 00:00:00
August | Project Number96 | ABC/A11/Y1/C096 | 2 | 2011-08-02 00:00:00 | 2011-08-03 00:00:00
August | Project Number97 | ABC/A11/Y1/C097 | 2 | 2011-08-03 00:00:00 | 2011-08-05 00:00:00
August | Project Number98 | ABC/A11/Y1/C098 | 2 | 2011-08-03 00:00:00 | 2011-08-05 00:00:00
August | Project Number99 | ABC/A11/Y1/C099 | 2 | 2011-08-03 00:00:00 | 2011-08-05 00:00:00
August | Project Number100 | ABC/A11/Y1/C100 | 2 | 2011-08-01 00:00:00 | 2011-08-01 00:00:00
August | Project Number101 | ABC/A11/Y1/C101 | 1 | 2011-07-31 00:00:00 | 2011-08-01 00:00:00
August | Project Number102 | ABC/A11/Y1/C102 | 1 | 2011-08-01 00:00:00 | 2011-08-05 00:00:00
August | Project Number103 | ABC/A11/Y1/C103 | 1 | 2011-08-01 00:00:00 | 2011-08-03 00:00:00