Hi,
Here are the basics:
1. Set up a criteria area where you will define which records (rows) you
want to extract (copy) to the new location. Here is an example:
Dept Salary
Acct >50000
This criteria range has two title which must match the titles in the data
source. The two conditions are that the department name is Acct and the
salary is >50000.
2. Select the data source, with titles and choose Data, Filter, Advanced
Filter
3. Choose Copy to another location
4. The List range should be correct, but if not correct it to include all
the data plus titles.
5. Select the Criteria Range box and highlight the criteria we created in
step 1, it must include the titles and the one row of conditions.
6. Select the Copy to box and enter a cell on the current sheet where you
want the data to be placed. Click OK.
Some notes:
1. These steps need to be modified if the destination range is on another
sheet, let us know if that is the case
2. If you don't want to bring data from all of the columns of your original
source to the output, then enter the field names on a row in the output area
and select those cells in step 6. Note the names must be spelled the same
(not case sensitive).
3. Warning: The command clears ALL cells in the destination area before it
copies the new data. This means all the way down to row 65,536 (2003). So
it is safer to specify a range for the Output rather than just a cell or row
of titles.
4. If you change the number of rows in the criteria area always redefine the
criteria range.
If this helps, please click the Yes button.
Cheers,
Shane DEvenshire
