| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare delete and copy lines
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare and delete in excel | Excel Worksheet Functions | |||
| Conditional formating: Compare two columns with Inserted lines | Excel Worksheet Functions | |||
| Compare & Delete | Excel Discussion (Misc queries) | |||
| Compare and delete or return value? | Excel Programming | |||
| Macro to search, compare, copy and delete | Excel Programming | |||
![sal21[_86_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
