advanced filtering

.AdvancedFilter works great if the .range data to filter and the .range criteria list are both within the same workbook. .AdvancedFilter does not seem to work if the .range data to filter is located in one open workbook, and the .range criteria data to filter is in a different open workbook...

So I have 2 fields Problem Work Performed Both can contain similar information, thus both can contain specific info. So far apps provide only AND operator. If I create filter for Problem and Work Performed. I will either miss information if one of the fields doesn't contain keyword, or I don't...

Morning all. I have a column on sheet 1 with different numbers in it (150, 300, 600, 900, 1500, 2500) ad would like to filter it based on the number given on sheet 2, cell B5 (I have the criteria listed on sheet 2 as well). I've tried manually writing the advanced filter macro, and when that...

Hi All, I'm looking for a way (if possible) to allow my filters in a pivot table be based off of an "if" statement or something similar. The data that i'm pulling from is a little complicated to write out... but here goes nothing. I work at a hotel and every night there is a snap shot of what...

Hi there, I am wanting to create an advanced filter to sort multiple coloured columns on a filter set from A1:Z1. The spreadsheet is a document that has been created to find any issues with any of the data in the document and highlights when there is an issue. The colours are often different...

Hellloooo Friends.. Can someone help me debug my Advanced filter. My end goal is to hide all rows that do no have "ABCD-201,ABCD-202,ABDC-203" in column A. 'Start my filters 'creating a Advanced filter to find ABCD With Sheets(2) .Range("AR1").NumberFormat =...

Scenario: Within same workbook, two tabs of data that need to be extracted to a third tab. Tab 3 - Master file 35K rows Tab 2 - Will very monthly Tab 1 - end result What I would like to do is: Using Tab 2, compare to Tab 3 master, if column B is equal in both tabs, then I would like to see...

Good morning, I'm creating a spreadsheet with a userform to filter data. The afflicted portion of the userform is basically just a bunch of comboboxes stacked on top of each other. The combo boxes are populated from several different tables. After the first combobox is selected, I'm hoping to...

Hi, I have a workbook with over 50 Sheets. I have set up advanced filters on in excess of 30 sheets. I would like to find a way to use VBA code to update the existing advanced filters that i have set when there is a chance to the woorkbook. I have managed to enter some code but it is based...

Hello: I have a report that is being dumped into excel. From that data, I have a Index Formula that is returning data based on client. When that data returns I need to be able to filter by date. I need to be able to type the date range in two separate cells. <tbody>...

I am new to VBA code, I am trying to create a search with 10 criteria in a userform, 2 of which are a start date and end date and the other 8 are categories and sub categories and descriptions. I want the option to leave some or all of the search criteria blank and return the full row of any...

Very new. First Post. I am building a tool for a manager to input employee schedules, see total hours and dollars in real time, and push out a csv file that will later be uploaded into our clock in system. So far, so good. I have an advanced filter that pulls data for each employee based on...

Dear all, I am working on a global email communications report covering 12 markets. As per the screenshot attached, I would like to filter results based on the cell value in D3 ("Austria") whereas D3 is a drop-down listing all 12 markets in two variants (one is just the market e.g. "Austria"...

Hi everyone, I am trying to analyse large amounts of ticketing data using Excel 2010. For each quarter, I need to separate about 120,000 rows of data into the following groups (and then save them to a new worksheet): <tbody> Adult only Senior Only Adults & Seniors Adults & Concessions...

Hi, I would like to filter one spreadsheet (inventory) with Item numbers from another spreadsheet (orders). My ideal situation would be to highlight the item numbers on the "Orders" spreadsheet, and then run a macro/vba script that will filter the list of items in the "Inventory" spreadsheet...

I have an old macro that lets me do an advanced filter on a table orginating in SQL. Because of a change in the values in the field i need to use wildcards. Before i had values like below Category SmG SmG/LTM SmG/Trade This was handlet with a filter that gave me all those with: Category SmG...

Hi, I am using Advanced filter to filter the data to a different location in the same book using a small macro code. The primary datasheet has working hyperlinks, although when the advanced filter copies the data to another sheet the text remains formatted but there are no hyperlinks...

Hi All, Just needing some help on this. The range element below needs to be dynamic. A1 and down meaning if i was to do this out of VBA I would hold CTRL+SHIFT+DOWN but i cant do that from macro record as it doesn't work, I'm guessing this Range("A1:A73") is the element I need to change but I...

I have searched the many threads of this forum that have similar questions, but I have not found what I really need. I have a sheet that pulls values from another sheet based on user selections. For the years selected, say 2014 to 2050 (37 columns), if all of the columns for that entry (Product...

Hi all, I am working on my advanced filter. I would like to find all date records that contain 2014. The issue is that some records contain Q1 2014, Q2 2014, etc and others have 2014 strictly as date. If i type in "2014" in the crteria ecxel will return all 2014 records BUT NOT q1 2014 nor q2...