Solved: Index match with command button

[tqm1]

Dear Experts

For index match, I am using following function, this works fine

=INDEX(Party!$B$2:$B$250,MATCH(Rpt_Daily!C6,Party!$A$2:$A$250,0)) 

source sheet=Party
Target Sheet=rpt_daily

Question-1

How to use above formula with command button.

I mean while pressing commandbutton, sheets("rpt_daily") must updated with sheets("Party")

Question-2

How to use above fourmat with offset() funciton?

Please help

[Bob Phillips]

Simple way

[vba]

Activecell.Value = ACtivesheet.Evaluate( _
"=INDEX(Party!$B$2:$B$250,MATCH(Rpt_Daily!C6,Party!$A$2:$A$250,0))")
[/vba]

What do you want to Offset?

[tqm1]

Dear Sir,

My I could not explain my problem?
So please see attachment and help me again

[Bob Phillips]

You certainly did not

[vba]

Private Sub CommandButton1_Click()
Dim iLastRow As Long
Dim i As Long

iLastRow = Me.Cells(Me.Rows.Count, "A").End(xlUp).Row
For i = 6 To iLastRow
Me.Cells(i, "D").Value = Me.Evaluate( _
"=INDEX(Party!$B$2:$B$250,MATCH(" & Me.Cells(i, "C").Address & ",Party!$A$2:$A$250,0))")
Next i
End Sub
[/vba]