I’m trying to find a solution online but it’s not been fruitful so far, I want to fetch the data in Columns 1,2,3,4,5,6,7 that is last edited in Sheet1 and then feed it into Sheet2.
Giving you an example, If the data is edited in Sheet1 C2 that data should be added into Sheet2 in A2 and B2
What I’m trying to achieve is, if anyone updated Sheet one, I want to know the last update in Sheet 2, is it possible to do this via scrip?
Sheet1 Screenshot
Sheet2 Screenshot
I tried a lot of script editing and tried to modify it… so far nothing worked for me. 🙁