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

No comments:
Post a Comment