activation01
12-08-2017, 11:24 AM
The request consists of updating a value between two tables (report 1 on the Excel file1.xls file and the report 2 table on the Excel file2.xls file), with a condition of taking the key (Column A / Column B) of the 1st file1.xls and change the value on the table the 2nd report2 which contains the same key (Column A / Column B) with the value of column C of the first report ,
Please note: note that the two tables are separate, two Excel files (rapport1.xls & rapport2.xls)
In piece joint the excel Templates.
File1.xlsx
rapport1
X type value
X1 A 20
X2 C 10
X3 A 2
X3 B 0
X1 D 5
File2.xlsx
rapport 2
X type update value
X1 A 0
X2 C 10
X3 A 1
X4 B -
X4 D -
thank's for your help & support
Please note: note that the two tables are separate, two Excel files (rapport1.xls & rapport2.xls)
In piece joint the excel Templates.
File1.xlsx
rapport1
X type value
X1 A 20
X2 C 10
X3 A 2
X3 B 0
X1 D 5
File2.xlsx
rapport 2
X type update value
X1 A 0
X2 C 10
X3 A 1
X4 B -
X4 D -
thank's for your help & support