Hello, there are two tables in Excell workbook, two different CSV documents with data :
Is there some way to UPDATE product price column in table Product Price List with values from column product new price from table Main Product Price List ?
After UPDATE was executed, table Product Price List should look like this :
I know how to write program in C# to UPDATE table, load two different excell csv documents and manipulate data inside to get desired result, but I am interested is there some way to do UPDATE trough some Excell functions, filters , or some internal Ecell script.
All the best,
Željko Peric.