Copy data from one excel cell to another sheet

[Lynx (Lnx)]

Good afternoon friends;

A query please, I am trying to copy data from one excel sheet to another (“SBS” to sheet1), I also tried with write range, but I did not have good results, with the write cell function, I am not sure it is the Ideal activity for this case, but it only writes in the first cell and does not advance to the others.

The idea is to look for each data from column “C” of sheet “Sheet1” in column “A” of sheet “SBS” and if it exists, copy the data from column “C” of “SBS” to the a the column “H” of the sheet “Sheet1”

Test_autorellenado_tipoCambio.zip (20.2 KB)

Thank you

Regards

[fernando_zuluaga]

Hey

so you want to pass data from SBS sheet into Sheet1, is that right?

also you want to add or modify data

[Lynx (Lnx)]

I already solved it, I had to make several changes with respect to what did previously

Solution.zip (45.4 KB)

Maybe it will serve somebody.