![]() This limits the copy to the number of rows and columns specified by the range. The final option is to select a range of cells. Thus, if the result of the filtering was 47 records, and your destination was a selection of 12 rows, only the first 12 records are copied. Excel will then only copy that many rows. In this case, make the destination a row selection. If you are working with a large list and the results of the filtering might be many, many rows, however, you might not want to do this. First, if you specify a single cell as the destination, then Excel copies the results of the filtering, regardless of the number of records extracted. When you specify a destination for the copy (step 6), you have three options. Specify a copy destination in the Copy To field. ![]()
0 Comments
Leave a Reply. |