How to write data from one excel to another excel for some specific condition

Help
1

Hi All,

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

Thanku

2

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?

4

Hiii @chenderson
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

Screenshot (53)
Screenshot (53)1366×768 128 KB