Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data storage/retrieval | Excel Discussion (Misc queries) | |||
Data Retrieval | Excel Discussion (Misc queries) | |||
Data Retrieval | Excel Programming | |||
HTML data retrieval | Excel Programming | |||
Troubles doing Data Retrieval from SQL | Excel Programming |