Extract data from drop down and add new coloumn into existing excel

Hello guys,
I am trying to select customer name from drop down list.
then i need to add column into existing excel and add values into column against each row (“Customer name” [“code”]), i need to add only code inside into row.
Please check the attached excel where i need to add coloumn and row value.(highlighted row)
Holdings07-05-2019.xlsx (10.3 KB)

Thanks in advance.

hello @abhijeetglobacom
you can try web record to get value from dropdown

  1. then add data column activity to add column
  2. add data row activity to add values

Hope its help


Sry i am not getting can please use design flow for better vision. and i want write this into excel

i attached workflow…this workflow not working as if but to demonstrate youclasswisesearch.xaml (12.7 KB)

hope its help

1 Like