Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forms / Lookup
Hi all,
I was wondering if any of you can help with below problem: I have a a few fields in Excel populated with information: Broker Name, Transaction Number, Stock Name, Quantity, Price, and Date. This information is on worksheet labeled "Data." Here's what I'd like to do; I want to create a form perhaps which would allow me to select a broker from a drop down arrow, along with another drop down arrow for a date. Once I click on a button that possibly says "Get Results", I'd like to be able to populate the cells below with all the transactions done by that particular broker (I'd like all the fields I've listed above to be included in the results.) Is there a simple way to do this. Also, I want to ave the option to view All brokers as well. Thanks in advance, Haas |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forms / Lookup
I need to do this in a form. However, if I can do an Auto Filter within
a form, and you can show me how to do so, I would love to learn that method. Thanks, Haas John Bundy (remove) wrote: Sounds like a perfect case for Auto-filter, or did this have to be done in a form? -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. " wrote: Hi all, I was wondering if any of you can help with below problem: I have a a few fields in Excel populated with information: Broker Name, Transaction Number, Stock Name, Quantity, Price, and Date. This information is on worksheet labeled "Data." Here's what I'd like to do; I want to create a form perhaps which would allow me to select a broker from a drop down arrow, along with another drop down arrow for a date. Once I click on a button that possibly says "Get Results", I'd like to be able to populate the cells below with all the transactions done by that particular broker (I'd like all the fields I've listed above to be included in the results.) Is there a simple way to do this. Also, I want to ave the option to view All brokers as well. Thanks in advance, Haas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup help. lookup result based on data in 2 columns | Excel Worksheet Functions | |||
Excel forms - authorise / deny forms | Excel Programming | |||
RefEdits and normal forms / forms in a DLL | Excel Programming | |||
Forms that open from forms | Excel Programming | |||
Calling Forms from Forms - Exit problems | Excel Programming |