M
moonhkt
Hi All
I have two Excel file. One Excel (A) create by User and other Excel
(B) is shared version posted on company shared directory.
I need update Worksheet B base on Worksheet A.
In Worksheet A, the key is Col A + Col B + Col Cm matched to Worksheet
B, the key is Col A + Col D + Col E
Below Column need to update WS A to WS B. The column may be changed.
After each Updated.
Work Sheet A -> WorkSheet B
I - > P
J ->Q
K ->R
....
Any suggestion to using VBA to Update Excel B ?
If Records not found in Excel B, Then create Record in Excel B.
moonhkt
I have two Excel file. One Excel (A) create by User and other Excel
(B) is shared version posted on company shared directory.
I need update Worksheet B base on Worksheet A.
In Worksheet A, the key is Col A + Col B + Col Cm matched to Worksheet
B, the key is Col A + Col D + Col E
Below Column need to update WS A to WS B. The column may be changed.
After each Updated.
Work Sheet A -> WorkSheet B
I - > P
J ->Q
K ->R
....
Any suggestion to using VBA to Update Excel B ?
If Records not found in Excel B, Then create Record in Excel B.
moonhkt