Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare and Lookup
Hi All, I need helps from all of you regarding the macro i need to do. The Attach file is the work that i had completed, but i need to mak some change to my marco, so i need help from all of the expert. THE MARCO I HAD DONE I want to compare between 2 worksheet named sheet1 and sheet2. sheet 2 work as source file. - If the value in sheet1 not exist in sheet2, set the status in colum B(sheet1) as "Canceled". - If the value in sheet2 not exist in sheet1, add new data to sheet and set status as "New". what i need now is make the changed of the column of data to belo example: _Sheet1:_ _Column_C__ _Column_F_ A B - Canceled C - new _Sheet2:_ _Column_Z___ _Column_AD_ A C Hope all of u can helps me. Thanks !! Sharo +------------------------------------------------------------------- |Filename: fwork v3.zip |Download: http://www.excelforum.com/attachment.php?postid=4189 +------------------------------------------------------------------- -- sharon200 ----------------------------------------------------------------------- sharon2006's Profile: http://www.excelforum.com/member.php...fo&userid=3017 View this thread: http://www.excelforum.com/showthread.php?threadid=49856 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup and compare | Excel Discussion (Misc queries) | |||
How do I lookup and compare cells? | Excel Worksheet Functions | |||
Lookup and Compare | Excel Discussion (Misc queries) | |||
Lookup function and compare | Excel Discussion (Misc queries) | |||
Lookup and compare rows | Excel Worksheet Functions |