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.