Search table, data retrieval

[Andyd74]

I am trying to retrieve data from a table on the push of a search button where the selection is based on at least 2 criteria being selected and then outputting this data in another cell. I.e. I want to retrieve the total value from one column in the table where the "name" is "Andy" and the "age" is "25".

I have this working using a normal SUMPRODUCT statement but i want this to happen on the click of a button. So Can someone suggest some VBA code that would allow me to do this.

Thanks

[Tom Ogilvy]

Private Sub CommandButton1_Click()
Range("B9").Value = Evaluate("your sumproduct formula")
End Sub

--
Regards,
Tom Ogilvy


"Andyd74" wrote:

>
> I am trying to retrieve data from a table on the push of a search button
> where the selection is based on at least 2 criteria being selected and
> then outputting this data in another cell. I.e. I want to retrieve the
> total value from one column in the table where the "name" is "Andy" and
> the "age" is "25".
>
> I have this working using a normal SUMPRODUCT statement but i want this
> to happen on the click of a button. So Can someone suggest some VBA code
> that would allow me to do this.
>
> Thanks
>
>
> --
> Andyd74
> ------------------------------------------------------------------------
> Andyd74's Profile: http://www.excelforum.com/member.php...o&userid=34013
> View this thread: http://www.excelforum.com/showthread...hreadid=537774
>
>