Automatic Data Update

K

Kanmi

How can i use macro to insert data from one workbook to another wookbook on a
particular columns without affecting other columns. For example.

A B C D
NAMES ID COURSE NAME SCORES

Kim 001 safety 60%
Larry 002 Lighty 80%
Buster 003 Wide 56%

Both workbooks have these heading. I want "destination.xls" to pull only
rows A and B(Names and ID) from the "source.xls." automatically everytime i
open it and if "Kim" appear twice it should only pull one "Kim". I mean in
case NAME "Kim" OR "ID" 001 Appear more than one time. Macro should only pick
the first one that appear to DESTINATION.XLS file. please can anybody help me
with this?. Thanks Appreciate your time.
 

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

Similar Threads

Automatic Data Insertion Between Workbooks 1
AUTOMATIC DATA ENTRY 3
Automatic Data Management 8
Copy Data Between two Workbook 0
VB CODE EDITOR 0
Automatic copy between two workbooks 4
HOW CAN I INSERT DATA BTW TWO WORKBOOK 1
Auto Change Notification 4

Top