Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I have foglio1 (with index into col AC) and foglio2 (with index into co AC) is possible to make a matching with this index and cut line fro sheet and copy into foglio3: Example: first condition: the index into sheet foglio1 col AC not is present in AC into foglio delete the entire line (range A:AI) of sheet2 and insert int sheet3... second condition: the line 3 and 4 from foglio1 not are present into foglio2 (index no present into foglio2) add this line into foglio2, delete from foglio1 Into example wbook attached, delete the line 2 and 3 from foglio2 an copy into foglio33 Into example wbook attached, copy the line 3 and 4 from foglio1 an copy into sheet3, delete from foglio1 into real wbook the number of line about foglio1 and foglio2 i 15000... +------------------------------------------------------------------- |Filename: Cartel1.zip |Download: http://www.excelforum.com/attachment.php?postid=4167 +------------------------------------------------------------------- -- sal2 ----------------------------------------------------------------------- sal21's Profile: http://www.excelforum.com/member.php...nfo&userid=204 View this thread: http://www.excelforum.com/showthread.php?threadid=49714 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compare cell = one result | Excel Discussion (Misc queries) | |||
compare one row to another and sum the result | Excel Discussion (Misc queries) | |||
Compare 2 different workbooks with the result in a 3rd | Excel Discussion (Misc queries) | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
compare data from one column with another and compare result to yet another | Excel Programming |