macro filter

Hello Gurus, Good day! Could you possibly help me tweak the code below? Scenario is I have to delete the data that is below 500 including blanks and zeroes in Column E. Headers is located in Row A Sub DeleteRowIF() Dim zlr As Long zlr = ActiveSheet.UsedRange.rows.Count With Range("A2:AZ"...

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...

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...

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...

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...

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...

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...

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...

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...

<!--[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>...

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: