Book test.xlsx (9.5 KB)
Above sample is attached. Here 2 different sheets are there. In this excel
the column is null or empty and required values are present in sheet2 .
By matching the order column values need to be updated.
how to do this, I tried by taking 2 for each but its not working.
Expected output:
if in both the sheets order column is matching then need to update the values in sheet1 where Number column is blank.
Please help me.
Thanks,
Lakshmi
@supermanPunch ,
Is there is any other method other than join data table.
Please help me.
I tried using 2 for each loop but not working
Thanks,
Lakshmi
I would read Sheet2 into datatable variable first, then loop Sheet1 rows one by one and check those rows where Number is not set yet. If not set, check if row’s Order is found from Sheet2 data. If so, take the first match from that Order from Sheet2 data and update the cell value in Sheet1.