The effect of the need to achieve:
1. After A column data points respectively button will be automatically assigned to the other columns (completed, look to whether can optimize)
2. This work has a lot of work table, in addition to the data, the village name in each worksheet contains many, every time "data" work there will be a lot of these input data in the table, then you need to these data processing automatically assigned to other work in the table (in the table according to other work area name automatically finds, "data" cell in the table name automatically assigned to the corresponding working table;
A column in the table 3. The other work, B and E column has A lot of formulas, runs slowly, is there A way to solve (A column is the calculated average, E column is according to the C column content automatically increase the date, and after the reservation date/time, B is the serial number, need to fill content automatically according to the C column in column B to add the serial number, delete or add contains middle row after the serial number automatically)
4. The "section" worksheet all work outside the "data" worksheet name corresponds to contain community name, under the "data" in the worksheet village names need to be automatically assigned to other work in the table (based on the "section" village name lookup table contains and write)
will suffix called XLSM reeal the EXCEL file