Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamically display subset rows from one sheet in another sheet?
Hi,
In my "first" sheet I have the following 3 columns of data: Person Date Choice a 1 z a 1 y a 2 z a 2 y a 3 y a 3 y a 3 y b 1 x b 1 y b 2 x b 2 y b 5 w b 5 z c 2 z c 3 x c 4 z c 5 w In the "second" sheet I want to: Step 1. Ask the user to enter one Person and one Date. Step 2. So if the user entered "a" and "2" then I would display: a 2 z a 2 y In the "second" sheet as the results. Step 3. Allow the user to clear his Person, Date and results. Step 4. Do another search by going to Step 1. My questions: What is the easiest way to do this? Can you give me the macro for this? Thanks, Luther ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamically display in Active Cell value from 2 rows above it | Excel Discussion (Misc queries) | |||
Transfer/Copy Sheet, Dynamically linked Sheet | Excel Discussion (Misc queries) | |||
Finding the maximum of a subset of values on a different sheet | Excel Discussion (Misc queries) | |||
Subset of one sheet on another sheet | Excel Discussion (Misc queries) | |||
Subset of one sheet on another sheet | Excel Worksheet Functions |