Update Worksheet data to other worksheets Data

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top