auto filter

  1. J

    Copy and paste from a sheet to different sheet with matching sheet name

    I have a Excel file with Header from A1 to H1 in sheet "RAW DATA" In the Column E of RAW DATA sheet I need to filter the data and paste into different sheet. There are 25 type of data in column E and I have 25 sheets with that matching Text as sheet name Presently I am copying data from Raw Data...
  2. E

    Autofilter, copy & paste vba not working

    Hi can someone have a look at the below and help with why it's not working? Warning it's messy! Sub Searchproper() ' ' copyandpaste Macro ' ' Sheets("HR Advice & Admin").Select FilterString = Sheets("Offer Received").Range("G5").Value ActiveSheet.Range("$A$1:$AS$286").AutoFilter...
  3. B

    Imitating Auto Filter

    I have a table of data that I need to then auto filter to return a subtotal across 11 columns and the works fine, however what I would really love is a front page to this data that automatically displays set criteria I would normally select to auto filter by. For example when I auto filter to a...
  4. K

    Defined Names contain autofilter ranges?

    I want to loop through all of the defined names pertaining to my sheet. That's the easy part, the issue i am encountering is that the workbook's many auto filter ranges must be stored as a defined name, which is not want i want. None of those filters were named intentionally. And the code i'm...
  5. C

    How to have one Pivot data update based on cell in another pivot table?

    Greetings all... I'm in a pickle jar... Let's say I am looking at 4 different store locations. In those locations I have several lines of products that we sell. I have 5 pivot charts setup all associated to the same data sheet. I am using a slicer to auto filter all the pivots depending on...
  6. S

    AutoFilter isn't working it goes to another row

    Thank you in advance! I have two issues with Autofilter 1. Autofilter is going to the first row instead of row 8 2. Is not filtering out blanks and/ or cells with formula that results in a "-" o dash Code: Sub hideemptyrows2() Worksheets("Indirect Cost Forecast").Activate Sheets("Indirect...
  7. P

    Auto Filter Causing Blank Hidden Pages to Print out

    In Excel 2013 -- I have created a worksheet that uses the auto filter function to hide rows (which are full pages when printed) of line items I don’t want to include in the final printout. In order to get the format to look good when printed, I have to use manual page breaks throughout the...
  8. B

    Auto Filtering Issues with VBA

    Essentially I am trying to filter Column Z by the months shown in cells B2:B4 upon the click of a button. So let's say that I have May through July showing in Cells B2:B4, once I click a button I want to Auto Filter Column Z to show only the rows that have dates between May and July. I know I...
  9. A

    Excel VBA - Filter, Copy and Paste to New Sheet

    Greetings, I am new to VBA and have the following query. I have a sheet with data in range A1:CL94. Row 1, 2 and 3 are headers. Row 4 is the filter header. A:A are the data to be filtered. Below table shows what it looks like. I need a macro that would Copy all 4 headers, filter the data by...
  10. R

    filtering names into a summary sheet

    Hi guys, I have the attached billing template. Now, I need to make a summary sheet for it. This summary sheet would have a name filter. For example, if I filter "Joe's" name, it would show data for Joe from all other worksheets. Can you please help me with this? By the way, I can't post the...
  11. P

    Filtering text strings containing multiple asterisks

    I am filtering a list of 400 text strings ( I have posted a subset below), some of which have anywhere from 1 to 4 asterisks. I know how to use the ~ to filter (both advanced filter and auto filter) for ANY number of asterisks: *~*. I also know how to use the ~ to advanced filter for more than...
  12. J

    Auto-Filter or Loop?

    I have been working on this macro for a little and got stuck, wondering if anybody has any suggestions. Ill post the code and the output below for reference. Excel Output & Code - Album on Imgur Everything under the last row with a category name in all caps ("CONTINGENCY" in this case) needs...
  13. G

    Able to uncheck item in column B's filter based on value found in column C with Excel VBA?

    I'm using Excel 2013 and I have a spreadsheet where the Filter setting is on. I am working on code that will uncheck an item in column B's filter if a certain value like, "Cat", is in column C. In the case below, it should just leave the Tree and Bark rows. <tbody> Fruit Filter Animal...
  14. 9

    Adding with Autofilters for YTD numbers from different worksheet

    I have two worksheets. One called Job Log with all the data and the summary report called YTD Summary. The Job Lob sheet has the following columns that need to be auto filtered: Business Division (column 2), Job Status (column 3), Units (column 9), Canada/US (column 17), Dollars (column 18)...
  15. R

    VBA Auto Filter on Server Connection

    Hi All I have created a VBA for filtering a table of values (see below) which works great, the reference used to filter the table is coming from another tab on the sheet. When i try and apply the same type of VBA filter on data table on another tab which is a connection to a SQL server it fails...
  16. P

    Autofilter for not equal to

    Hello All, I have a range of data in sheet 1 that I want to filter by column one. Column one contains cells like "BCX" and "DUV". I want to filter out rows that in column 1, start with the letters: B, X, N, C, V, M, L, H, and D. I then want to copy the remaining values to a new sheet. I have...
  17. O

    Re-applying auto filter on select worksheets

    Hi, I have the code below to help me re-apply auto filter on selected sheets. It take multiple data entries to get the filter to auto apply. Can someone help me clean this up? Thanks! Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target...
  18. PritishS

    Autofilter Macro removes the password proteection from a protected sheet

    Hi, My requirement: I'm using MS-Excel 2007. I have a protected sheet with 10 columns where I applied filter. during protecting my sheet I have selected the option 'AutoFilter" checked. But the problem I faced, if I filter data from all 10 columns, I cant reset all filters in a single click. I...
  19. H

    COUNTIF function for filtered tables

    Dear Madame /Sir I am using an excel sheet where I am applying auto filters using VBA. In Column 6 , I have type of training (eLearning, InClass, Webex) and in column 7, I have time required for the training. After applying filter I am able to see how many hours of training required for...
  20. XfortunaX

    Email Attachments from Auto-filtered Cell

    Hello, I am using Excel 2010 The code below works flawlessly on the first time around: For I = 2 To Range("F" & Rows.Count).End(xlUp).Row .Attachments.Add Range("F" & I).Value Next I The second time around. It adds all of the rows from the first filter and the second, not just visible rows...
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