copy filtered data

  1. M

    Excel VBA Macro - Filter Information, Create New Workbook

    I have a large data set that I need to filter for category and use. That is to say, filter column D and then filter column E. D is the category and E is the use. Category A has 3 uses, Category B has 4 uses, Category C has 17 uses and Category D has 4 uses. I filter by category then individually...
    • md457
    • Thread
    • copy filtered data macros multiple filter criteria newworkbook
    • Replies: 3
    • Forum: Excel Questions
  2. N

    VBA Filter copy table with no data - copy whole table

    Hello, I'm not the best at this yet so please don't judge my code below... I am having a problem in the code where I highlighted it blue. I know there are some options like using an IF statement but I can never get those to work. We have 13 tabs for the 13 weeks in the quarter. As you can see...
    • Nerdalert314
    • Thread
    • copy filtered data if statement replaceformat=false searchformat=false table filters
    • Replies: 1
    • Forum: Excel Questions
  3. Lingots d or

    Copy data from a filtered selection to the first empty rows on another sheet

    Hi all, This one may be easy for you, but I've only been doing macros for about a week now and need help on it. (I managed to automatize a bit of my work already with minimal knowledge and I'm very enthusiast about the power of VBA and want to do more). This particular thread is for these...
  4. I

    Copying Autofiltered Results in VBA

    hi, I am using an autofilter to trim some results according to a specific criteria, i want to then copy this data to a sheet called "funds". then want to repeat this with the next criteria. I have the filter working fine. I just cannot seem to get this copying across to this new sheet...
  5. A

    Table Range and Dynamic Range

    I have a table A:AE with expanding data. I want to filter this data and select only 3 of the columns to copy, L-U-Y. After I filter I then set the range to copy I can't seem to set that range to always match the current Table range. I have searched this forum and others. I am either not...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top