Excel help needed

[HamdanKhanIslam]

Below attached is example. There are 2 tables in that sheet.
In one table, I have names in one column and places in other. The names are constant but places are updating.
And on other Table, I have written the name one time. And I want to have their updated place status from table 1. How can I do that? Please help.

[#2]

Hi @HamdanKhanIslam

Are you searching for anything like this?

https://techcommunity.microsoft.com/t5/microsoft-learn/excel-auto-transfer-data-between-column/m-p/2...

Best regards,
Schnittlauch

"First, No system is safe. Second, Aim for the impossible. Third, no Backup, no Mercy" - Schnittlauch

My answer helped you? Don't forget to leave a like. Also mark the answer as solved when your problem is solved. :)

[#3]

Need help in this chart.
I want to have a updated status of Battery bank in "last maintenance" column and "battery" column. So I can easily determine when to plan next next maintenance.