Hello Everyone, I have been trying to achieve this and failing miserably.
Requirement: a)Compare the data in Files named John.xlsx with Jack.xlsx b)Specifically compare the Columns B and C . c)If both Columns match, then move the entire ROW from Jack.xlsx to a third file Lilian.xlsx which will be having the same columns headers and is just a blank file at the moment. d)Delete the moved row from Jack.xlsx e)Save Jack.xlsx and Lilian .xlsx Does that make any sense? Attaching sample data for all the three spreadsheets mentioned above. Jack : https://docs.google.com/spreadsheets/d/1GUuNFkJdgpStfLH1oBTAvxEgW9V1v13Z5aJ9goA8C0M/edit?usp=sharing John : https://docs.google.com/spreadsheets/d/1B9LObbHmu0G9pBHbFqbcR4fNJuSr8BvpqJHfVi9J2fg/edit?usp=sharing Lilian : https://docs.google.com/spreadsheets/d/1JiFNrMeq9F9-7oSJULXo4yqzYK3eRXnphDJbubBIlLE/edit?usp=sharing Any advice is appreciated. Thank you! -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
