Updating table with data from another table
I want to insert Employee No., Basic Pay from 'Employee' table into 'Loan' table, and at the same time I want to insert a value for 'Loan Amount' column of 'Loans' table. You need to at least know the "connecting" piece of information between the two tables in order to do this.It appears that in your example, the connecting column is the Employee No column.If the workbook did not previously contain a model, it does now.A model is created automatically when you create a relationship between two tables or click Add to Data Model in Power Pivot. Now that you have a linked table, you can edit any cell in the worksheet, including adding and removing rows and columns.In Excel 2007 and later, you can format a list as a Named Table, and use that as a dynamic source for your Pivot Table.
Adding a linked table is as easy as selecting a range and clicking Add to Data Model.If you are bored with the predefined formats, you can easily define your own table formatting color schemes and apply them.When you create a table, zebra lines come as a bonus.Better yet, format the range as table so that you can give it a proper name.Working with a named linked table makes calculations and relationships easier to manage.