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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamically display subset rows from one sheet in another sheet?
easiest?
make a PivotTable. No code needed. Excel will do it all for ya! keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool lothario wrote: Hi, In my "first" sheet I have the following 3 columns of data: 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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamically display subset rows from one sheet in another sheet?
Or set the auto filter on the first sheet and do not even use
the second one. The used will just select what they want from the drop down options on the columns of the auto filter. Use the menu Data -- Filter -- Autofilter Chrissy. keepitcool wrote easiest? make a PivotTable. No code needed. Excel will do it all for ya! keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool lothario wrote: Hi, In my "first" sheet I have the following 3 columns of data: 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/ |
Reply |
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 |