I have a table in which
ID Product Name 1 Alto 2 Aveo 3 Aveo UVA 4 A star 5 Eeco 6 800 7 Omni 8 Zen 9 Zen Estilo 10 Versa
.... and so on of database of over 300 products
Now i have created a new sheet in the said spreadsheet Have a created a drop down list to select from Product Name However want ID to be automatically filled and in a separate column based on Product Name selected.
Excel Sheet Data