There are two main methods to copy filtered data to a new location in Excel:

Method 1: Using "Go To Special"

1. Select the visible data: With your filter applied, ensure only the filtered data is showing.
2. Go to "Home" tab: Click on the "Home" tab in the Excel ribbon.
3. Find & Select: Locate the "Find & Select" section and click the dropdown arrow.
4. Go To Special: Choose "Go To Special" from the dropdown menu.
5. Select "Visible cells only": In the "Go To Special" dialog box, check the option "Visible cells only."
6. Click OK: Click the "OK" button to select only the visible filtered data.
7. Copy and Paste: Now that only the filtered data is selected, press Ctrl+C to copy it.
8. Choose the new location: Navigate to the desired location in your worksheet (new sheet or specific cell range) where you want to paste the filtered data.
9. Paste: Press Ctrl+V to paste the copied filtered data.

Method 2: Using Advanced Filter (For complex scenarios)

1. Prepare the destination range: In your new location, ensure you have a blank cell range large enough to accommodate the copied data.
2. Copy the data range: Select the entire data range that contains your original data (not just the filtered view).
3. Go to "Data" tab: Click on the "Data" tab in the ribbon.
4. Advanced Filter: Locate the "Advanced" group and click on "Advanced Filter."
5. Copy to another location: Check the box for "Copy to another location."
6. Define the range: In the "Range" box, enter the cell address of your blank destination range from step 1.
7. Criteria range (Optional): If you have specific criteria to further filter the data within the advanced filter options, define that range here. Otherwise, leave it blank.
8. Copy as values (Optional): You can choose to copy the data with formulas (default) or just the values by checking the "Copy as values" box.
9. Click OK: Click the "OK" button to apply the advanced filter and copy the filtered data to your chosen location.

Note: Method 1 is simpler for basic scenarios, while Method 2 offers more control for complex filtering needs. Choose the approach that best suits your situation.