Showing posts with label Advance Filter. Show all posts
Showing posts with label Advance Filter. Show all posts

Dec 10, 2008

QA Using Advance Filter for Conditional List

When Want Make the List Conditional List
Step 1. Select ListRange(What Original Data Range)
Step 2. Data/Filter/Advance Filter Menu Select
Step 3. Select Copt to Another Location
Step 4. Set Range as below
List Range = Selected ListRange(What Original Data Range)(Maybe Auto Wrote)
Criteria Range = Manual Select
Copy to = Manual Select

Important
Criteria Range /Copy to / Range's Header Must Same Value List Range's Header Value


Locations of visitors to this page