Can anyone Help me...

[imranfarooq]

[TABLE="width: 614"]
<tbody>[TR]
[TD]Hi[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5"]I am trying to update my updatesheet data to mastersheet via headers with vba. Anyone can help me[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Master Sheet[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]First Name[/TD]
[TD]Last Name[/TD]
[TD]Age[/TD]
[TD]Salary ($)[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]John[/TD]
[TD]Smith[/TD]
[TD]50[/TD]
[TD]5000[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]John[/TD]
[TD]Smith[/TD]
[TD]45[/TD]
[TD]2000[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]J.[/TD]
[TD]John[/TD]
[TD]40[/TD]
[TD]2800[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Update Sheet[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]First Name[/TD]
[TD]Last Name[/TD]
[TD]Age[/TD]
[TD]Salary ($)[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]John[/TD]
[TD]Smith[/TD]
[TD]50[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]John[/TD]
[TD]Smith[/TD]
[TD]45[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]J.[/TD]
[TD]John[/TD]
[TD]40[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[ranman256]

Can you just copy column D?

 

[Aladin Akyurek]

Book1
	A	B	C	D
1	First Name	Last Name	Age	Salary ($)
2	John	Smith	50	5000
3	John	Smith	45	2000
4	J.	John	40	2800
master

Book1
	A	B	C	D
1	First Name	Last Name	Age	Salary ($)
2	John	Smith	50	5000
3	John	Smith	45	2000
4	J.	John	40	2800
update

In D2 of update control+shift+enter, not just enter, and copy down:

=INDEX(master!$D$2:$D$4,SMALL(IF(master!$A$2:$A$4=A2,IF(master!$B$2:$B$4=B2,ROW(master!$A$2:$D$4)-ROW(INDEX(master!$A$2:$D$4,1,1))+1)),COUNTIFS($A$2:A2,A2,$B$2:B2,B2)))