compare and copy...

[sal21 s via OfficeKB.com]

================================
http://www.GSSITALY.COM/compare.ZIP

or signle wbook

http://www.GSSITALY.COM/MASTER.XLS

http://www.GSSITALY.COM/USER.XLS
================================
i have this 2 wbook in c:\verifiche\

Note: i open for this work the wbook MASTER, and i would want to maintain
into dir the wbook USER

i would want to compare ad copy value of USER column R, into column R of
MASTER in this mode and with 2 condition (in VBA):

condition number 1)
the value of column R of USER is present into same column R of MASTER, copy
the value of column Q of USER into column Q of MASTER...

condition number 2)
the value of column R of USER is not present into same column R of MASTER,
insert into column Q of MASTER the value "NEW"

Tthat its all...