View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sal21 sal21 is offline
external usenet poster
 
Posts: 45
Default compare cell and insert vaalue in column Q


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

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