Copy cell based on condition in Excel

Hi,

I want to copy cell in column H to column I if column I is null. For example, I1 is null, so I want to copy H1 to I1.

I want to do it for each row.

image

2 Likes

Then after you copy what next ? @Atakan_Kiziltan

cheers :smiley:

Happy learning :smiley:

3 Likes

Paste to column I :slight_smile:

1 Like
  1. On your read range, specify the range parameter to “A:I”, outputs datatable from A to I Column
  2. For each row of dtoutput
    if(String.IsNullorEmpty(row(8).ToString))
    {
    Write cell,
    text = row(7).ToSTring
    cellposition = “I” + (rowindex+2).ToString
    }
2 Likes

@Atakan_Kiziltan

PFA workflow as per your requirement.

Excelexample.zip (65.8 KB)

Regards,
A Manohar

1 Like