LinkBack URL
About LinkBacks
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,
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,
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.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
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
Power Query is your best option.
The M code:
Please Login or Register to view this content.
Thank you so much, that worked great!!
No problem!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks