advanced filter

  1. A

    Excel Advanced Filter, Clear/.ShowAllData leaving weird formatting

    Hi Everyone, I've got a couple of issues with a search function I'm building. The first is that sometimes the filter won't return all available results. This is something that I've only come across as I've been trying to figure this issue out and made a new sheet with a smaller data set to try...
  2. H

    Filter with multiple criteria dropdown list

    Hello, I am currently working on a spreadsheet with many data, including a dropdown list with multiple selection (I used a VBA code to activate it). Now, on another sheet, I need to extract data from the initial one by using the dropdown list as a criteria, but the advance filter is not...
  3. A

    Advanced Filter: contains specific text

    I put together an advanced filter to only show rows that match my selection from a drop-down menu. I used function =IF(E6=“”,”*”,E6) and recorded a macro to extract data from one sheet and display in my filtered table on another sheet. It works well, but I’ve run into a wall. I have some cells...
  4. BPW

    VBA - xlFilterCopy/CopyToRange - Paste Special to retain destination formatting?

    Hi Everyone, I'm stuck and need a little guidance. I'm attempting to copy unique values within a column of one worksheet and paste them within another worksheet (same workbook) retaining the destination sheet's formatting. Below is the VBA that pastes over the formatting. Sub...
  5. B

    Filter Column based off another Column List

    Hi Everyone, If I wanted to filter data that was in Column AH by data provided from Column AC how would I do that? Let's say Column AH has 50 values while Column AC here has 10. I want to filter using Column AC first value (YOG6LOHSP) to show all of the same values in Column AH(YOG6LOHSP)...
  6. T

    Filter loop through macro

    I have various workbooks that I need to check the data in by filtering on various columns to find those that need to be checked and then I filter through the resultant list using usually column 'C', checking line by line and marking those 'done'. What I'd like to achieve is a button that...
  7. D

    Search for a column and filter 3 or more names with wildcards

    Hi Friends, I request your help here for a code to search for a column using column name and filter data using wildcards. ABC, PQR, and XYZ are part of the same team but no other column to identify teams and therefore they need to be searched at once from the given data. Below code was...
  8. K

    Problem with Advanced filter in excel 2007

    Hello, i cant find what Iam doing wrong, I have quiet complex table (9199 rows actually and colums from A to FE) I wish to use just 2 columns for filtering, but i need to get few combinations of data extracted. 1st column iam using for criteria should search for like values Data1 - Data6 and...
  9. H

    Advanced filter from another workbook

    Fluff very kindly posted the following code to enable the automation of advanced filtering from one worksheet to another in the same workbook for variable criteria without having to reinput the criteria each time. But how would this be done from another workbook? The data is in a workbook...
  10. M

    Advanced Filter

    How would you set up advanced filter if you want to collect records of a dataset that contain numbers stored as text, and you want them starting with the partial text 646&"*" or 647&"*". I have a dataset where a column contains account code in text format such 6****** and I want all of those...
  11. G

    Mixing Advanced Filters and Normal Filters

    Good afternoon! So I am trying to sat up an automatic report for my job where I can use advance filters to type the selected months into the criteria page and have it filter per those months. The macro however uses both Advanced and Normal filters and when I transition between, the entire table...
  12. R

    Excel VBA: First execution of Advanced Filter returns header, and then the filtered results

    I have an Advanced Filter set up in my spreadsheet, and rather than showing all of the filtered results at once, I have it set up so it cycles through them one by one. But I have noticed that the first time I click the button that executes the script, it returns the header value first and then...
  13. R

    Excel VBA Advanced Filter Multiple Comboboxes Userform Listbox - How to?

    Hi I'm a first time poster so apologies in advance if any of the below is not allowed or does not make sense etc. I'm more than happy to amend it/clarify anything. I have a userform which allows me to view values in worksheet1 using a listbox. I have several textboxes on the userform which...
  14. A

    Advanced Filter Macro Help

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

    Find Replace from a list of words

    Hello! I can't seem to be able to find any help in regard to this, nor can I find any excel add-ons that can do this seemingly easy task. I have a huge list of URL's on my spreadsheet, and I need to remove certain domains such as social media sites and various others. I can do this manually...
  16. R

    VBA Advanced Filter

    I have some code that currently looks for two criteria. <colgroup><col><col></colgroup><tbody> Date Requested Approved? 2/24/2019 Approved </tbody> I would like to add pending as a criteria under approved too. so that if the column has approved or pending it will show up. bellow is what i...
  17. L

    Advanced Filter for all colours on multiple columns

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

    refine advanced filter

    Is there a better, more efficient way to complete all these advanced filters? Sub Sort() Sheets("RequestLog").Columns("A:G").AdvancedFilter Action:=xlFilterCopy, _ CriteriaRange:=Range("Calendar!l4:M5"), CopyToRange:=Range("Calendar!l8:m15"), Unique:=False...
  19. R

    Advanced Filter Too Long

    Is there a way to simplify the following code? It is not very efficient and it take a little while to run. each line sorts for different criteria. Sub Sort() Sheets("RequestLog").Columns("A:G").AdvancedFilter Action:=xlFilterCopy, _ CriteriaRange:=Range("Calendar!l4:M5")...
  20. CsJHUN

    VBA advanced filters with multiple data in one cell

    Hello guys, I need your help again,i have this as an input <colgroup><col style="mso-width-source:userset;mso-width-alt:3808;width:89pt" width="119"> <col style="mso-width-source:userset;mso-width-alt:3744; width:88pt" width="117" span="2"> <col...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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