sal21
11-24-2005, 05:15 AM
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 here:
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...
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 here:
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...