look for ID in 2 sheets and map details

[kshitij_dch]

Hi,

I have a workbook in which sheet 1 has few ID and name with details and sheet 2 is having list of ID and name with details .

Looking for a macro which will match the ID in sheet1 with sheet2 , if ID matches then look for the amount in column D if amount is same in both the sheets then copy the place and name from sheet 2 to sheet1

Sheet 1
ID	Names	Place	Amount
11	Antony	Texas	231
22	Rodger	Mexico	-639
33	Marcos	USA	-300
44	Lily	Brazil	500

<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>

Sheet 2
ID	Names	Place	Amount
11	Antony	Brazil	231
11	Antony	USA	-231
44	Lily	Texas	500
33	Marcos	Mexico	-300
44	Lily	Hungary	-231
22	Rodger	Texas	639
22	Rodger	Hungary	-639

<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>

 

[Fazza]

What happens when the proposed solution is used with the sample data (your post #1 )?

 

[kshitij_dch]

hello Folks , is there any way that we get to know after running a macro what changes are made by macro in a sheet

 

[Fazza]

which macro?

(If this is a general question, best addressed in a new thread.)

 

[Fazza]

PS.
If you need to know what has changed, maybe have the macro record/show what has changed.
How would you want the changes to be shown?
cheers