How to copy data that only has data to other cells


I need help. I want to copy the values ​​in column C to column A without changing all the contents of the data in column A (example only the contents of C3 to A3, C10 to A10 and C14 to A14). anyone can help? Thank You

Hi @wsinten

For Each row As datarow In in_DT.Rows
If Not String.IsNullOrEmpty(row(“C”).ToString) Then
row(“A”) = row(“C”).ToString
End If

Try this code. Hope this helps

Hi @wsinten

what about the following?


Check this workflow.
Filter.xaml (8.4 KB)

Hi @fernando_zuluaga thank you for your answer. But still not working.

Hi @Suraj_B_Shetty,

thank you for wanting to answer me. but your file can’t be opened on me. can you just take a screenshot for me? thank you

Hi @wsinten

i made a mistake check this now

Not(String.IsNullOrEmpty(CurrentRow(2).ToString())) OrElse Not(String.IsNullOrWhiteSpace(CurrentRow(2).ToString()))

you can also change the index number of the columns for your columns names


Use this inside invoke code

Pass Arguments

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.