compare cell and insert vaalue in column Q

[sal21]

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

[Leith Ross]

Hello Sal21,

This macro will do what you asked based on the information and worksheets you provided. If you have any problems, you can reach me by email at [email protected].

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[sal21]

Hello Sal21,

This macro will do what you asked based on the information and worksheets you provided. If you have any problems, you can reach me by email at [email protected].

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Hi, Leith Ross
Tks for code. It work well....
But, why not insert the value "new" in other cell of sheet MASTER, when not exist correpondence from USER to MASTER?
I attache my sheet master with my idea...Your macro put the value new only in cell 408 of MASTER
Sorry for my english but sure you have understand me, you have posted me a good code.
Coffe a nd pizza are for you...

[Leith Ross]

Hello Sal21,

This code should put "New" into the Master cell if there is no correspondce with the User cell or the Master cell has a number, but no description.

Please Login or Register  to view this content.

By the way, if you have trouble writing something in English, feel free to write it in Italian. I am part Italian and can read it pretty well.

Ciao,
Leith Ross