i have this 2 wbook in c:\verifiche\

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

i would want to compare ad copy value of USER column R, into column
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 o
MASTER, insert into column Q of MASTER the value "NEW"

i have mke it with a formula but i would want insert a module with VB
for Excel into MASTER

Tthat its all..

+-------------------------------------------------------------------
|Filename: COMPARA.zip
|Download: http://www.excelforum.com/attachment.php?postid=3927
+-------------------------------------------------------------------

--
sal2

-----------------------------------------------------------------------
sal21's Profile: http://www.excelforum.com/member.php...nfo&userid=204
View this thread: http://www.excelforum.com/showthread.php?threadid=47792