Can anyone Help me...

[imranfarooq]

Hi
I am trying to update my updatesheet data to mastersheet via headers with vba. Anyone can help me
Master Sheet
	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 Sheet
	A	B	C	D
1	First Name	Last Name	Age	Salary ($)
2	John	Smith	50
3	John	Smith	45
4	J.	John	40

<tbody>
</tbody>

 

[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)))