filtering dynamic data

  1. Y

    Need macro snippet for Filtering Non-Repetitive, Dynamic data/values for Repetitive macro usage.

    Hi, I have to copy rows from one sheet to other in a same excel file. It's a repetitive task to be conducted on weekly basis. Consider following example. Name Devices code A Desktop 234 B Laptop 2345 C Television 3456 D Smartphone 7654 E Printer NA F Desktop 098 G Scanner NA...
    • Yup
    • Thread
    • blank cell dynamic data excel exclude blank cells filtering dynamic data include blank cells macro macro for auto filter non repeating unique data vba
    • Replies: 9
    • Forum: Excel Questions
  2. 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
  3. 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
  4. A

    Filtering in Excel with Cumulative Value

    <tbody></tbody> <colgroup><col><col><col><col><col></colgroup><tbody> Player (Filter) Competition (Filter) Venue (Filter) Bonus Gross Bonus Vardy EPL Home 50 50 Huth FA cup Away 30 80 Fuchs Carling Cup Home 25 105 Gray Champion League Home 70 175 Vardy Champion League Away 100...
    • akpflow
    • Thread
    • dynamic cell filter filtering dynamic data gross pay
    • Replies: 5
    • Forum: Excel Questions
  5. A

    Filtering in Corresponding Gross Value using VBA in Excel

    Good day... I'm new in this forum... I have a spreadsheet that uses filter to narrow down my search/selection but the gross value doesn't change. I would love an excel shhet that has the corresponding gross value as the filter changes. I can send you a dummy file for clarity. Best, Akpflow...
    • akpflow
    • Thread
    • auto adjusting filtering dynamic data gross margin vba & excel 2013 vba - filter
    • Replies: 2
    • Forum: Excel Questions
  6. A

    Issues with Macro to import data from web, create pivot table & filter it based on a dynamic range

    Hi All, I'm a newbie with VB & macros, i've been recording a macro manually and tried to edit it with bits and pieces that i found on several forums. It does work to a certain extent but i'm hitting several issues. i have a workbook with 3 sheets "NECA ASR Pivot Table", "Install Compliance...
    • Anikipipo
    • Thread
    • filtering dynamic data import data by vba pivot table by vba
    • Replies: 4
    • Forum: Excel Questions
  7. C

    Need help determing functions, programming needed for Worksheet (to help a cancer patient)

    <tbody> First of all, thank you in advance for your help with the four questions I have below! Background: I am trying to help a doctor communicate to a cancer patient about her medications, and for the patient to have a worksheet to check off all the meds she is supposed to take each time of...
    • carolbien
    • Thread
    • data validation vlookup filtering dynamic data linking data worksheets pivot automation
    • Replies: 2
    • Forum: Excel Questions
  8. U

    Filter out (hide) "0" value when other values are dynamic

    Hi, Column A has values that are dynamic references that change based on other inputs. Some rows will often have no data, so the value for these in column A is "0". I need a macro that will filter OUT all the rows with "0". The problem is that when I record my macro, it actually filters IN...

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