Use script to populate one sheet from data of another sheet

by Stefan Axelsson   Last Updated October 12, 2018 12:03 PM

I have a problem with writing a script to input data from one sheet to another.

Here is what I have:

In sheet1 I have a list of products with a unique number in column A. In sheet2 I want to be able to type in different unique numbers (same as in sheet1) and enter a price, after I have done that I want the script to be run by pressing a button updating the price column in sheet1, after that I want the data to be cleared in sheet2, in order to enter new products and prices to do the same over an over again.

In other words I will have a 2 columns 10 rows range in sheet2 where I want to look up the unique row in sheet1 (using columnA in sheet2 to look up column A in sheet1) and update the price in column I from column B in sheet2.

Related Questions

Which is better: onEdit or onChange trigger?

Updated August 14, 2018 16:03 PM

Google App Script - changeType "REMOVE_GRID"

Updated June 29, 2018 15:03 PM