Filter And Copy To Different Place

Once we filter the data we can copy that data in other cells as well in Excel sheet.



To copy to a different location: 


1) When we click on Filter and Advanced Filter option we get the below dialog box.

2) Here we have three options:

• List range is the range of data that is to be filtered.
• Criteria Range is the entire data from which data needs to be filtered.
• Copy to pastes the filtered data to a different location.

We select the data and the cells and we will get the filtered data in the cell that is there in Copy to cell range.

Posted in: Copy filtered data to a different location,Filter and copy to different place,Microsoft Excel 2003,Microsoft Office Support,PC Support,Technical Support,TechSupp247