Update one Column in table from another table

[fabian_76]

Hi,

Can someone help me to get a formula to automatically update ColA (in table T_EMP, in sheet2) with information typed in ColB (from table T_NewEmp in sheet1).

Thanks,

[AliGW]

Your question lacks important detail. Please provide some sample data so that we can see the nature of the data and what connects the two tables.

[fabian_76]

thank you!.

Attached is an file. Source data and where people enter the name of the employee is sheet "EMPLOYEE". Once they finish typing I want the second sheet to update "RECAP".

Both data must be tables and have the same number of employees. As you can see Sheet "EMPLOYEE" has Cesar and Fabian whereas "RECAP" does not.

Thanks, again

[AliGW]

Power Query is your best option.

The M code:

Please Login or Register  to view this content.

[fabian_76]

Thank you so much, that worked great!!

[AliGW]

No problem!