Search table, data retrieval
 

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

Search table, data retrieval
 

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