i have sheet SERVIZIO (is hided) and sheet RATE and sheet DEFINITE...
Is possible to match all line from SERVIZIO to RATE with index in
column AC (is unique ID) and recopy the line not found in SERVIZIO into
sheet DEFINITE...

In this case the dirrence is 800 line into sheet RATE and 506 lines
into SERVIZIO recopy 224 not found line in sheet DEFINITE

the file is he
http://www2.rapidupload.com/d.php?f...p;filepath=2332

example:

With the first value in column AC of RATE, scanning into column AC of
SERVIZIO, the value of RATE not is founded in SERVIZIO, delete this
line from RATE and copy into DEFINITE...
With the next value in column AC of RATE, scanning into column AC of
SERVIZIO, the value of RATE not is founded in SERVIZIO, delete this
line from RATE and copy into DEFINITE...

ecc...


--
sal21


------------------------------------------------------------------------
sal21's Profile: http://www.excelforum.com/member.php...fo&userid=2040
View this thread: http://www.excelforum.com/showthread...hreadid=487910