macro filter

  1. B

    Macro using cell value

    Hello all, I need help on this please. I need to use the value from cell (B5)'sheet1' in a filter on sheet2. When I record my macro I am copying and pasting the value of B5 over to sheet2 filter and then copying and pasting the results back over to sheet1. This is working but the problem is...
  2. T

    VBA filter grand total if blanks, if not skip filter

    Hello, I am trying to edit a macro with some pivot tables. I am extremely novice with VBA editing and I would be extremely appreciative of your help :-). The macro creates a pivot table and grand totals for monthly data. Sometimes the grand total must be adjusted with filters. At times I need...
  3. T

    Macro, skip filter command if fields aren't present in data and continue running macro

    Hello, I have data sets that need filtering in pivot tables in a macro. Sometimes the data has blanks and unwanted fields. How do I tell the macro to skip/bypass the filter command for unwanted said fields when the fields aren't present in the data and to continue running macro as normal...
  4. T

    Macro filter field, if field is not present, skip filter

    Hello,I have a MACRO that needs to filter out certain fields. However, the data won't always contain these fields. When these fields aren't present the macro errors out. How can the macro filter out these fields when they are present and just skip this command when they are not present...
  5. R

    Using VBA to update a Pivot Table filter based on the value in a cell

    Hello, I have a workbook with a tab (Individual) containing a cell (PT_Individual_ID), that is a specific customer ID, and 2 pivot tables which read a database contained in the second tab of the workbook. I want to be able to enter the customer ID and have the filters on the pivot tables update...
  6. M

    Macro to Filter Criteria Based on Table

    I am trying to filter out data based on specific data that changes based on location, I am trying to see if their is a way to adjust the filter code to use the data on a list I created as the filter criteria, once it has gone through the whole list it would continue with the rest of the macro...
  7. D

    basic macro help

    hi all i created a macro to run off of some filtered data, and copied a formula down, but when the data gets updated the now filtered rows do not match where i had copied the formula, so the formula is on rows that i do not want and is returning n/a's. is it possible to write a code that will...
  8. A

    Filtering out "0" in Table during Macro

    Hey all, I'm working on an inventory model for my company, but have hit a bit of a roadblock. I want the user to be able to fill in the number of bottles of wine we currently have, which is then subtracted from the number there ought to be, therefore leaving a difference which we need to...
  9. S

    Macro to filter based on lists

    <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...
  10. E

    Macro to Filter on a Date

    Problem: I need the date to be input by a user in a cell on one file, then have a column in a data file filtered for dates greater than or equal to that date. Any help is appreciated! :confused:

Some videos you may like

This Week's Hot Topics

Top