how write the function for if we write or change one tab of google sheet excel to other tab it will automatically change how
how to change or modify one tab to other tab in google excel. how to write the formula for one table of one tab of google excel sheet like 1st it have to search for KAI project name and find person name after that there it have to replace id number instead of ticket like that and it especially if i change or update new in other tab it has to update here automatically in 1st tab. explain and give example. what if i have more than 1tickets
