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