is there any alternative IMPORTRANGE Google app script for spreadsheets to cross update the sheets? : I used the IMPORTRANGE but we can not edit the data in another sheet where we fetched this.
SO I found this script https://www.youtube.com/watch?v=PZtb3lRWn74  but same case here also.

Is there any method or script so we can import only few columns and cross update them from both/any of these sheets?