autofilter dynamic range

  1. Y

    Need a Macro code to filter & unselect a specific value.

    Hi, I have to copy rows from one sheet to other in a same excel file. It's a repetitive task. Consider following example. Name Devices code A Desktop 234 B Laptop 2345 C Laptop 3456 D Smartphone 7654 E Printer 3456 F Desktop 098 G Scanner 123 H Laptop 65 I Smartphone 876 J...
    • Yup
    • Thread
    • autofilter autofilter criteria autofilter dynamic range criteria dynamic data excel filter filtering dynamic data macro
    • Replies: 10
    • Forum: Excel Questions
  2. Y

    Macro code to autofilter & select dynamic data.

    Hi, I have to copy rows from one sheet to other in a same excel file. It's a repetitive task. Consider following example. Name Devices code A Desktop 234 B Laptop 2345 C Laptop 3456 D Smartphone 7654 E Printer 3456 F Desktop 098 G Scanner 123 H Laptop 65 I Smartphone 876 J...
    • Yup
    • Thread
    • autofilter autofilter criteria autofilter dynamic range critera excel filtering dynamic data macro
    • Replies: 2
    • Forum: Excel Questions
  3. K

    autofilter with dynamic range

    Hi A Newby here. I've have used the macro recorder to perform certain tasks (see macro code below) but need help adjusting code to make available for a dynamic range as the macro will be used on different data sets. As you can see when I autofilter on the 2nd column it records the number of...
    • keyss22
    • Thread
    • autofilter dynamic range data dynamic macro rows
    • Replies: 5
    • Forum: Excel Questions

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