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

Help
1

Hello guys,
I am trying to select customer name from drop down list.
customer%20name%20from%20drop%20down
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.

2

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

image
image926×419 40.6 KB

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

Hope its help
Thanks

2 Likes
3

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

4

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

hope its help
thanks

1 Like