filtering

I'm having trouble filtering what's in a pivot table using VBA. I have a large pivot table, but for sake of brevity, the attached sample is essentially the same thing. In this sample, I'm getting kicked back with a 1004 error that it can't find the referenced PivotField. Here's the code...

Hello, I need help, i have a workbook with alot on information and i want to record some macros to save me sometime and get the information i want. 1. I want a macro for filtering. I recorded a macro for filtering (select a person from the drop down and it filters the product that person...

Hi Everyone, I am really stuck how to do this, but am hoping it will be a great learning experience. I look forward to taking the solution here and using it to expand.... :) I have a big spreadsheet, A1 - AL of headers The file is about 900 lines long. The data I need to pull is just the...

I read somewhere that we should not have blank cells if we are going to use filter. Is that correct? I just tried it myself and I do not have problem filtering even when I have blank cells or rows. Thank you

Hello everyone, I was wondering if it is possible to generate a formula in excel which is doing operations based on content of another cell. I know that this is quite easy to do with sorting and filtering button, but i would like to do it with formula so I can apply it on large dataset. I...

I've written a formula that sums up a large database and allows filtering based on the values of F4, F5, and F6. For F5, the filtering options are All, DSS, 1, 2, 3, 4. The following formula works great to do this. =SUMPRODUCT(database[Total Boards],--(database[[Date]:[Date]]<='Pareto...

Hi, I have 2 sheets A and B, Inn sheets A, I have criteria to filter the data on sheets B. Cell A5 value = "Civil" and I have a button beside the cell to run the macro for filtering data on sheets . How is the code to filter data based on range value of cell A5 in sheets A, so when I changed...

Hi Team, I am looking for a formula in B3, Such a that if I found a Cell value (Gold or Silver) in Cell A3, then I want the answer Best in Column (b3). Else dont change any value in B3. Then i want to drag the formula till last cell value. Through Filtering I can get the result, I am looking...

Hi Team, I need your help here. 1. I have 2 spread sheet with some data in it which requires some filtering and formatting. i.e. in both spread sheet a) Delete row A1 to A12 b) Filter col CW and select only "Unprocessed" c) Filter Col CV and select text filter and choose contain "FX" d)...

Hi Team, I need your help here. 1. I have 2 spread sheet with some data in it which requires some filtering and formatting. i.e. in both spread sheet a) Delete row A1 to A12 b) Filter col CW and select only "Unprocessed" c) Filter Col CV and select text filter and choose contain "FX" d) copy...

Hi, Would someone who can help me on how to count how many rows after sorting or filtering by using formula. thanks in advance. gigi

Hello everyone, I have the following issue: I am doing a long and complex filtering within a table where each filtering process starts at the beginning of a certain Column where it then reads its cells content. In the middle of that filtering process, changes are done to other columns based on...

I don't know how to use SQL to write "in less than" "Today-10 days" using the wizard. I just started using SQL and hope this is the write place to ask. The column I'm filtering is a date so the in less than comes write up, but i don't know how to do the second part.

Hey Excel Wizards, I need some help. I have some data that has names in multiple columns. These columns share the same list of names. It is a table tracking who was the lead on a job and who worked with him. Now what I want to do is be able to pull all the data associated with a name no...

My husband is starting a website on Shopify. The wholesaler who is supplying the merchandise will send an Excel sheet every day with their updated inventory list. We are supposed to upload this list every morning, which is simple. However, he only wants to sell about a third of what they...

First off... For those of you who have helped me build this macro I've been working on for the better part of a month, thank you! Excel MVPs and experts, this has been a learning process for me, and I cannot tell you how grateful I am for your help and patience. Currently, I am coming towards...

I have a database from A1:I1001, with Row 1 as the header. Need a VBA to filter data using 3 criterion, in columns B, H and I based on the value input in cells M1, N1 and O1 respectively. Easy so far... the catch is the following.... Column B has Long names....like.... Aditya Birla Sun...

I have Y and N answers in a multiple category spreadsheet. I am trying to pull them into a Pivot Table but, cannot seem to get it filtered correctly. The counts and Y/N are not filtering correctly. <tbody> Filters Columns NONE VALUE Rows Values CORRELATED DATA ALL COLUMNS...

Without using a pivot table, because I'm only dealing with ~3,000 tenure-related records, is there an efficient way to group and/or filter (on the following without doing nested IF's? I'd like to have groups of (0 - 5 years, 5 - 10 years, etc.). Note: I have Power Pivot but I don't think it...

Hi All, I'm new in the group. Can anyone help me to apply filtering for a range of date from different columns in excel .