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.

  • Welcome. Please add a brief description of your search/research efforts. Ref How to Ask. – Rubén Oct 12 '18 at 11:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.