compare delete and copy lines

S

sal21

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Want code to copy to ABOVE row 22 column A on sheet 1 10
update access from excel - jamie collins are you ready for new adventure;-) 0
Count Value And Blank Cells Value. 0
Copy and paste 4
Pasting to Cells to the Right. 2
match, copy, paste, & color 2
Auto Copy Data from one worksheet to another 1
Find all in one sheet 3

Top