View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sal21 s via OfficeKB.com sal21 s via OfficeKB.com is offline
external usenet poster
 
Posts: 1
Default compare and copy...

================================
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...


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200510/1