excel, to a worksheet in a few data automatically copied to another worksheet …

For example, I have two worksheets, namely Table 1 (data), Table 2 (empty), Table 1 in the name, number, size, number of sex-disaggregated data, I want to be a form of data entry or update After the A column of Table 2 automatically generates a table in the name of the data, Table 2, column B of Table 1 automatically generated in the area of data (Note:Table 1 in the name of the field not to generate Table 2, so to say Table 2 of the first acts of air, the data generated from the beginning of the second line), to help errant, it is best to use VBA

As long as the toolbar will be able to enter the formula, such as:
two worksheet open, click on the second line of Table 2, column A, column formula importation “= [Book1] Sheet1! $ A $ 1”, to Car, the cursor will be placed on the bottom right corner of the cell into a black cross, right down to promote other cells on the formula automatically, and then the can.Book1 is your first name, if it is under the same document The different forms do not need to enter the
would like to help you need to do so complex, the first copy of the data needs of Table 1, Table 2 in the appropriate location of the Paste Special, non pasting links you can.When the Table 1 Data entry or after 2 naturally updated.