How can I copy the data of sheet 1 to sheet 2 with modify?

For Example:

sheet 1:

File Num Vendor Code
1________m1
2________m2
original pmmld
3________m3


sheet 2:
File Num Vendor Code
1________m1
2________m2
3________m3


From above example, it will NOT copy "original pmmid".

Please let me know, thanks.


--
accessman2
------------------------------------------------------------------------
accessman2's Profile: http://www.excelforum.com/member.php...o&userid=27953
View this thread: http://www.excelforum.com/showthread...hreadid=475715