filtered data

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

    Copying filtered data across sheets.

    Hi Guys, I have a workbook which has multiple sheets and a summary sheet. Lets say I have 11 sheets on the workbook with the first being my summary and the other 10 being pages with my data. On each of my data sheets there are columns which then have rows filtered based on critea for each...
  20. Z

    Automatically Keep Filtered Data on New Worksheet Up-to-Date

    I currently have a Workbook with five Worksheets, organized thus: Worksheet1 - actual data, 5 columns (B:F). Worksheet2 - would like this Worksheet to display filtered data (data from Worksheet1 where a certain value is found in Column2) Worksheet3 - same as Worksheet2, but with a different...

Some videos you may like

This Week's Hot Topics

Top