Copy a specific row to another based on a value in the column

[RudrakshPandey]

Hi Everyone,

I wanted to copy the whole row into a new row if the column B contains a specific value.

In the attached sheet, if the Column B has the value ATF XYZ, I would like that whole row to be copied again.

Thanks,

Rudraksh

[flying008 · Accepted solution]

Hi, @RudrakshPandey 

FYI.

RowCount <= IIF(Contains([Name], 'ATF XYZ'), 2, 1)

[RudrakshPandey]

Thank you @flying008  for helping out.