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.

Sorry, but this newsgroup is for questions about Access, the database
product that's part of Office Professional.

Macros in Access are a very different thing than what are called macros in
the other Office products.

You'd be best off reposting your question to a newsgroup related to Excel.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Kanmi" <(E-Mail Removed)> wrote in message
news:57F0FA20-9AB2-4997-9706-(E-Mail Removed)...
> 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.