After importing FIND en CHANGE corresporending value
 

Hello,

I have imported data from Access to Excel. Now I want to modify the
values which have corresponding ID's. Does anyone have allreadt solved
this problem. Please help me out i'm running out of time.

Example:

Sheet 1 Sheet Import
******** *************
ID LineID AM ID LineID AM
-- ------ --- -- ------ ---
01 100 562 01 100 500 (562-500)
01 101 578 01 101 564 (578-564)
02 100 714 02 100 650 (714-650)
03 500 471 03 500 400 (471-400)
03 501 897 03 501 579 (897-579)

AM of Sheet 1 need's to be changed by AM of Import Sheet!!