hello everyone,I want to write to the blank cell ,filld with the row number and the id.
for example,if the line that id=3,I need to fill in the B4 with “4+3”.
And suppose I don’t know where is the blank cell.
Thank you very much
B5 cell fill with “5+4”
Use dictionary & get empty space, then use write cell & write in that
Use Read Range activity to get the data to Data Table (dt).
Use For Each Row activity
inside use IF activity to check that value is empty or not
If True-> use Assign activity to update that value
Then use write range activity to update the data.
Main.xaml (15.0 KB)
what if I don’t know the id?
thanks for your reply