Compare cells and fill data in excel

Good afternoon friends;
compare_and_fill.xlsx (11.1 KB)

One query please, I would like to fill in the exchange rate in the sheet “data” column “D” according to the date, taking as reference the date and the exchange rate that is in the sheet “ref”.

The final result should be like this:

In the “data” sheet the date is in yyyy.mm.dd format and in the “ref” sheet the date is in dd/mm/yyyy format

The final result should be like this:

Thank you very much in advance

Hi @Lynx

Read range-to read first excel sheet (data)
Read range-to read second sheet(ref)
for each row in datable(data)
Inside this one more for each row in data table(ref)
convert the date format of 25.01.2021 to 25-01-2021 by using CurrentRow[2].ToString().Replace(“.”,“-”)

Then refer the screenshot


Finally write the datable data in first sheet (data)

Thanks

1 Like

Thank you very much for your answer @sangeethaneelavannan1 I’m going to try now and let you know.

1 Like

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