1. N

    AutoFilter Results into a user Selection

    Hello! I am trying to create a code that after an autofilter, if there are multiple results then some type of inquiry pops up to allow the user to choose the best option. For example after an autoFilter the following results are showing: Ms Excel TAKE OFF from Spec MOC ITEM Smaller Bigger...
  2. N

    Excel VBA : Applying Vlookup To filtered range

    Hi All, I need to vlookup on a filtered range using VBA. I have gone through different threads posted on same topic, however they can't actually answer my question. Basically the sheet where I need to perform the lookup, will be received via User input. My code goes as follows : Option...
  3. P

    How to copy only the visible line of Autofilter and paste only values

    Hi, I've been trying to work with my excel data where I need to copy data from one sheet to another sheet. In the source sheet I have the following data Doc nr (A) Date (B) Name (C) Nr (D) Cost (E) Amount TCY (E) Currency (F) Description (G) Amount LCY (H) Account2 (I) 5646546 31100...
  4. M

    Need to get Sum of a Column based on values satisfying criteria in 6 different columns

    I have a requirement to evaluate a sum of a single column, if 5 other columns satisfy individual criteria. Each of this columns would have array of values. Considering following subset of data DIFFERENCE_PERIOD_NET PERIOD_NET_DR PERIOD_NET_CR PERIOD_NUM SEGMENT1 SEGMENT2 SEGMENT3 SEGMENT4...
  5. J

    AutoFilter out cells by colour

    Hi all, I'm trying to filter out certain cells in a column that I have filled as green. I only want to see the cells that are not green. Normally I filter out by using the following code change the colour of certain cells and it works okay: To change the colour of certain cells I use...
  6. T

    Copy/paste Filtered range into table VBA

    Hello, I am trying to filter data from one sheet and copy/paste that filtered data over into a summary sheet. I have 2 criteria that, if met, need to go into two separate summary tables. I am able to get the data filtered and copied, however, when it pastes into the respective tables, it is...
  7. J

    Getting an error when AutoFiltering 2 criteria

    Hey guys, I'm trying to AutoFilter column B (in this case UK cities). I want to AutoFilter every city not equal to London and Manchester. The code I'm using is: ActiveSheet.Range("A1").AutoFilter field:=2, Criteria1:="<>London", Operators:=xlOr, Criteria2:="<>Manchester" I'm getting a...
  8. D

    Autofilter at row 4 and copy filtered visible rows from 6 and futher on

    Hi All, I am struggling to get certain rows copied from sheet "Data" into another workbook with autofilter. I want to autofilter --> row 4 --> field 170 --> "<>" --> and copy all visible lines starting from row 5. Then I want to paste these visible lines as value into another workbook also at...
  9. R

    Autofilter to include Headers

    Hi All, I have excel file with templates which looks something like this. I am trying to filter down rows based on customer ID column and create PDF . I am using below VBA code to do the job. Public Sub Create_PDFs() Dim CustomerIDsDict As Object, CustomerID As Variant Dim r As...
  10. S

    AutoFilter method of Range class failed, Error 1004

    Hi there, I consider myself a novice at VBA and have managed to put together a UserForm that can search a worksheet and edit data. At some point along the line I seem to have broken the code as I can no longer search. The below is my code. The piece of code giving me this error is in red. Code...
  11. littlepete

    convert to table but loose all macros ?

    Hello, I can see the advantages for an excel table, i've tried it before, but all the articles give always examples that belong to the mathematics and statistics not to an address list, or text containing list... when i try to convert to a table i immediately see that my macros dont work...
  12. wsnyder

    Get All Visible Rows After AutoFilter

    Hi all, Using Excel 365. How do I get all visible rows count after autofilter so I can loop through visible values to pass to another sub.? I tired to get a new Range of visible rows which appears to give the correct non-contiguous address, but not the correct count of visible rows Thanks, -w...
  13. wsnyder

    ListObject AutoFilter FilterMode

    Hi all, Using Excel 365. My snippet is throwing an error here If lo.FilterMode Then Not sure why that is? Thanks -w Full snippet: Sub ShowAll_Lists() Dim wb As Workbook Dim ws As Worksheet Dim lo As ListObject Set wb = ThisWorkbook For Each ws In wb.Worksheets For Each lo In...
  14. 5

    Speed up an Autofilter with 20k+ rows

    Hey everyone. Hope you're all doing well. I have a listObject table with 20k+ rows that I'm filtering with a textbox. This is the code I modified a little from extendoffice: Private Sub TextBox1_Change() 'Update by Extendoffice 2018/08/22 Dim xStr, xName As String Dim xWS As Worksheet Dim xRg...
  15. T

    Filter Geography (rich data type) columns using multiple SubField parameters via VBA

    I am trying to figure out how the new rich data type fields (Geography and Stocks) work with respect to auto filters and VBA. For example, suppose I have a table with header "City" and five cities: "New York", "Los Angeles", "San Francisco", "Toronto" and "Boston". The cities have the...
  16. R

    VBA Autofilter not working! (3 criteria Array)

    Calamity! Have this autofilter: Range("A1:W" & Lastrowaf1).AutoFilter field:=12, Criteria1:=Array(bkdate, bkdate2, bkdate3), Operator:=xlFilterValues ' Booking Date Lastrowaf1 is working (12,000 rows), field 12 is the autofilter field (contains date as serial, 44242 etc) bkdate, bkdate2...
  17. H

    How to stop RE on autofilter VBA macro

    I have a number of VBA macros which autofilter, hide certain columns, then copy the results, minus the header row, to another sheet. By and large they work well, but when there is nothing to copy, there is generally a RE on the line indicating the destination sheet Here is just one of the...
  18. A

    Copy rows onto another worksheet based on multiple criteria (dynamic criteria)

    I'm trying to copy rows from one sheet to another worksheet based on a number of criteria (currently from a dropdown). I am currently able to do this for non-dynamic (non-changing) criteria using either an excel formula or VBA coda (which is much faster). However, how can I set up my macro so...
  19. P

    AutoFill Formula from ActiveCell till the last cells of other columns having data.

    Hi there, My Name is Prathik. I'd like to apologize if this question has already been answered. I didn't find anything about this anywhere on the internet. So posting it here. Please assist. So I'm writing this code wherein my macro writes a formula in E2 (Range A To D already has data). Then...
  20. V

    Write to First Visible Cell after autoFilter in VBA

    Hello Have a great day, I am very new to Macros and want to create a dynamic macro and automate my day to day task . I wrote code to copy data from other workbooks and append it on other workbook(testmac) I applied a filter and select the All amount which are greater than Zero in Column K Now...
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