auto filter

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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)...
  14. 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...
  15. 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...
  16. 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...
  17. P

    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...
  18. 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...
  19. 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...
  20. C

    Need help using AutoFilter on a Range in VBA

    Hi! Row 3 has a column header labeled "Description" and I want to filter out all cells containing the words "tech" & "qa" in that column. My macro can find the column and the DesRng can find the correct cells But..my last line of code (with the Auto Filters) will not work :( I think this is...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top