filtered data

  1. SanjayGMusafir

    Macro to Go To an intended date in a filtered range

    Hi Experts Recently, I got help from @kevin9999 in the following post Once I got things working, I thought exploring options and adding more conditions to it. Now I realized that instead of jumping to...
  2. SanjayGMusafir

    VBA to Go to Today in a filtered range

    Hi Experts I use following code to jump to today in a filtered range. It works well when table is sorted by date first and then by any other field. But challenge arises when table is sorted first by any other field and then by date. In such cases present date(s) can be around 1000+ rows...
  3. T

    Macro to copy rows from various sheets to the master sheet. Rows filtered by input on the master sheet.

    Hi All, I've been searching various forums for days with an answer to my issue without success. I've found answers that partially work, but don't quite do what I want. I'm pulling my hair out and would appreciate any help. I currently have a workbook which pulls in raw data from hundreds of...
  4. A

    Copying entire from filtered table onto another table

    Hello I've been struggling with a VBA solution for this and would appreciate your valuable help. I have a named table range, whose headers are on row 14. I need to filter its contents and move filtered data to another table. Number of filtered rows will always be variable, but will always...
  5. G

    filtered data showing on listbox - userform

    Hi, i am trying to figure out why the following code doesnt show only filtered data on the listbox. Can someone help me please? Dim rData As Range With Blad1 Set rData = .Range(.Cells(1, 1), .Cells(.Rows.Count, 5).End(xlUp)) If Not .AutoFilterMode Then .Cells(1, 1).AutoFilter...
  6. F

    How to return row matching value in filtered data?

    Hi everyone, I have a filtered table, and I need to find the first row which matches a value. However "MATCH" formula will return the row of first match in all the data not just the filtered data. I'm a little stumped by this one and can't figure it out. Any recommendations? Thanks in...
  7. K

    Increment to next visible line via vba

    I'm creating another data file (KML for import into google earth) from data in a table. Pretty basic stuff. I can't get this loop running because it keeps incrementing by exactly one line. The code works fine except in the scenario where I use excel's filter function to shorten the list...
  8. J

    paste formula into only filtered cell

    Sub Macro10() Dim LastRowColumnA As Long: LastRowColumnA = Sheets("Sayn").Cells(Rows.Count, 1).End(xlUp).Row ActiveSheet.Range("G4:L4").AutoFilter Field:=5, Criteria1:="<>YES" _ , Operator:=xlAnd Range("H5:H" & LastRowColumnA).SpecialCells(xlCellTypeVisible).FormulaR1C1 = "0" end...
  9. R

    Formula or macro to hide cell information for hidden row

    Is there a formula that will display the status of the current row? I'm using filters to show/hide rows; however, I have a range that is displaying information about each respective rows. I have a VBA macro that then lists the information in the range but it shows everything including the...
  10. C

    Set Filtered Data Print Area (Include Last 6 Rows As Continued Data)

    Hi guys! I really need your help regarding the print area. I am working on a file that is so complicated. It has header, filtered data and last part (signatory). So here is my problem. If ever I filter the data that I have, the print area of my file still includes all the data - both filtered...
  11. H

    Copy filtered data with gaps to new worksheet.

    Hi, I have filtered data that will change in volume on a weekly basis, i cant figure out how to copy the data down to the last record including all the gaps in the data (keeping the gaps) and paste into a new worksheet. The macro i've been using originally... Sheets("New Load").Select...
  12. M

    Need macro solution to copy/paste formula from first filtered cell

    I need a macro solution to perform the following tasks... 1. Filter column A for all blanks 2. Select first resulting cell and enter a formula in it 3. Copy that formula into columns B thru O then down to last row in filtered list 4. Copy all new formula cells and paste value over them
  13. B

    Change VBA to insert copied rows not paste them.

    Hello! I am new to VBA as you will probably be able to tell. I have read a lot on this forum and I am having a great time learning! I have Office 2013 and Windows 8.1(dont knwo if that matters but to much information is better than not enough!) My problem: I need to copy rows of data from the...
  14. K

    Creating Summary sheet - VLOOKUPS/INDEX Returning Multiple Values

    Hi, I hope someone can help me with the best solution for this. I have a tab that contains thousands of different records, both rows and columns. I want to create a summary sheet that only gives me certain columns and based on 2 lookup values. The user would change these 2 values to suit...
  15. M

    VBA GetPivotData doesn't return a wanted 0

    Hi I have this pivot issue that I'd like to have some help with. I'm using VBA to write a macro that should pick values from a Pivot and put them in a table. Say for example I am selling clothes. I can get a "Count of Clothes" using: iVal = myWorkSheet.myPivot.GetPivotData("Count of...
  16. R

    Hyperlink to a sheet and filter data

    I want to be able to link a projects name cell to the issues sheet within the same spreadsheet and only show issues for that project. I did find this thread that asked same question, but had not solutions posted...
  17. 1

    Get Excel 2007 to consider only filtered cells

    Hi, I have put on a filter in my sheet and want to copy certain values from Column W to column X with the filter on. However, when I copy across the values with the filter still on it is ignoring the filter and just replacing the values sequentially. For example with the filter on I have rows...
  18. T

    Name a range that's been filtered

    I've been looking everywhere for this answer with no luck, so props to whomever can tackle this! What I need is the code for naming a range that's been filtered. For example, in my macro I'm telling it to filter like so: Selection.AutoFilter Field:=2, Criteria1:="320" Now, what I need to...
  19. R

    Recognize filtered records

    Hello, This is my question/problem. On my first worksheet I have a lot of records. Frequently I use the Autofilter to select a subset. After that I want a statistic summary of the filtered records. My macro goes from top to bottom and uses all of the records. How can I limit the macro tot the...
  20. D

    Please Help - Complex "Count" Formula Needed on Filtered Cells

    I'm hoping that someone can help me. I need a formula that can provide counts with the following criteria - please assume XL2003. I have searched and searched - to no avail. 1. Data is filtered on one or more columns Assume data is filtered on column D - to exclude "Free" 2. Data Range...

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