In the form control I am trying assign the input range to a row of cells. It
is not working. dropdown list is filled only with the first cell content.
my idea is to put one dropdown for each column in sheet2
sheet1 contains some products with information - one column for each product.
I want the product names to be filled from top row of sheet1.
by choosing one product from the list, that column data is copied from
sheet2 column for that product.
Thank you
MVM