I want to write data from one excel sheet to another excel sheet but the condition is that in if F column its contain match so it does not write the data from one excel to another but its find blank space in F Column then it get the data and write one sheet to another
Good evening Purva,
I may be misunderstanding your question, but it appears you want to use the “Filter Data Table” activity on your datatable to remove any rows where the value in Column F is blank/empty.
Then you can just write the remaining rows to the other Excel workbook.
Is this correct?
Thanks for reply you can see the below attachment in F column there are match but some are blank so I want to get data from blank/empty cell and write into another excel using the write range activity