filtered data

Hi Experts Recently, I got help from @kevin9999 in the following post https://www.mrexcel.com/board/threads/vba-to-go-to-today-in-a-filtered-range.1223005/ Once I got things working, I thought exploring options and adding more conditions to it. Now I realized that instead of jumping to...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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

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...

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...

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...

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...

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...

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...

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...

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...