1.Searched the value (ABCDE) in website.
2.Get the result and store it in the excel file.(B2 cell)
3.Go back searched the (LMNOP) in website.
4.Get the result and store the value in scrapped column. (B3 cell)
But the value overhere gets replaced in B2 cell. Which command I should write to store the value in new cell.
Use write cell activity where you can mention a counter variable.
Range = “B”+counter_variable.
Initialize it will default value as 2 and increment the value after Write cell activity
if you are using write cell you can increment the number of cell, for example b+counter and increment the counter
Hi @VIDIT_ZALA
You must be using ForEachRow Activity. Within that you will see the properties panel der is output section which gives you the index. SO declare a variable der as follows.
And within Write Cell Activity just mention as i have shown in the below SS
This will get the current row value index that you are searching for in the website and will append it to the Scrapped column for that same row
Mark as solution and like it 
Happy Automation 
Best Regards
Er Pratik Wavhal 
@Pratik_Wavhal
Can this work in Write Range activity?
Hi @VIDIT_ZALA
See below img
Write Range activity requires the datatable
So it depends on the data what you are extracting. If you are extracting the data that returns the data table then its ok to use Write Range Activity.
If as per the eg you gave der is only one value which returns String/Text that you extract and write it into a particular cell then you must use Write Cell.
Mark as solution and like it if this helps you
Happy Automation
Best Regards
Er Pratik Wavhal
@Pratik_Wavhal
1.I have created the flowchart of the process where in Read Range activity we read the excel data.
In read range activity I have used ReadDT as output variable.You can see in the below image.
2.Open browser contains the login process.
3.For each row does the main process where I am facing the issue.Check the below image for better understanding.
Hi @VIDIT_ZALA
The thing you have done is totally right. I dont see any issue der until now.
The way it should be is der already.
Happy Automation
Best Regards
Er Pratik Wavhal
Hi @Pratik_Wavhal
Thanks for reply but I am not able get my desired output.
All the values get replaced in B2 cell.
Hi @VIDIT_ZALA
So as i previously said you that will be better as per my experience
dummyVariable will be the datatable variable you got from extracting data from website
One by one it will write into cell in the increment way
Happy Automation
Best Regards
Er Pratik Wavhal
@Pratik_Wavhal Thank you for help I have achieved what I was looking for 
