filtering

Referencing the image below, I created the following filtering criteria within Advanced Filtering in order to filter my Data Set. Within the Advance Filter entry window, when I set my criteria range to filter based on the date criteria only the advance filtering works just fine. However...

Hello all, I have problems using the code below. It does the work filtering and getting the right columns however it copies the same columns millions of times up to row 1048576 Could you please help me?. Many thanks. Rose Sub Filtering() Dim Lastrow As Long With Sheets("Sheet1") If...

Can anyone explain why I find it so much faster to run my workbooks created in Excel 365 in Excel 2003 compatibilty mode? Even with some complicated and very long VBA macros including colour sorting and also using Data Advanced Filtering I have not found anything that I use that will not work...

hi, after filtering...i want to count the number of rows used from after the headers...the headers fill in the top 6 rows and the data is row 7 and below (from columns A to N)....essentially i just want vba to tell me how many rows are used today after doing some sort of filtering and excluding...

Hi, Expert I am new in a Excel. I went to get you expert solution for creating a VBA code for Auto Filtering System. How Can I do it. Thanks in advanced.

Hello guys, im trying to filter some data and add it into an array My filtering code is: If Sheets(sheetName).AutoFilterMode Then Sheets(sheetName).AutoFilter.ShowAllData lastCol = Cells(1, Columns.Count).End(xlToLeft).Column lastRow = Cells(Rows.Count...

Hi, I've hunted around for code for my problem and thought this would work but doesn't. I have a table where I want to filter 'Country Name' = to 'Country' value listed on another sheet. (Then, copy the data from that table to other cells. - which I think I have worked out) Option Explicit...

Hi Guys, I wonder if there is any possibility, to use a hyper link from PPT to an EXCEL file. Once the Excel file is opened, the immediate action will be Auto Filtering to the exact value that i have clicked on hyper link. For example: the Hyper link value is: 'Diagnostic' - opens a linked...

The idea is to have a topic selection page where i can select yes or no and then based on my answers the next sheet will show all of the topics that i answers yes to. Images can be seen here: https://ibb.co/YfKK6pG AND https://ibb.co/1GpyjmJ Looking it this it maybe could be something where...

Hi All, I am sure that this is an easy fix for those that know what they are doing (unlike me). I have a background color surrounding a pivot table in Excel, but when I filter out column entries, this leaves blank non-formatted cells in the pivot from the filtering. What I am wanting to do is...

Hi, I am a bit stick trying to replicate the work of my former colleague at work. Some time ago he create a Power BI visualisation of annual costs with a lot of simple filtering options (departments, sub-departments,...). Recreating that in Power BI is no problem, but he somehow made the output...

I'm trying to create a Dashboard with slicers and pivot charts from a pivot table. I'm struggling with creating filters from the different columns I have in my pivot table. They are in the "VALUES" section from the pivot property. I would like to do 2 things mostly: Be able to filter from the...

Hi can anyone help with the following code for filtering Data and with Formulas for Counting Data? I have Headers in Columns "A2:J2" and Data in "A3:J" Sheet1 I have the following macro that deletes all visible rows when filtering the data in columns "D:J" but I don't want to delete the...

Hi there, I have created an action plan that has a main menu that filters the action plan as required. One of the macros looks at filtering for items that are due within either 15 days, 30 days or now (I don’t have one for overdue yet). I have set up based on some advice what the macro should...

Hey guys! I have in Excel/ Power Query a regular date column (DD.MM.YYYY). I would like to filter this column for year 2018 in total and 2019 to date. So for today 01.01.2018-05.02.2019. Is there any function for this? How can I manage this? best regards

Hi This code literally returns the first value of my table regardless to whether a filter is applied and the row hidden; Worksheets("C&I Calculator").Range("C14").Value = Worksheets("Live Deals").Range("N5", Cells(Rows.Count, "N").End(xlUp)).Cells(2, 1) But I want it to return the...

I have a table with formulas where I have inserted a filter at the top. But everytime I make a filter on oneof the columns, it start recalculating. I cannot just set the calculationsto ‘Manual’, since I’m supposed to change some of the cells where it afterwards should becalculating. Is there...

Hello everyone, I am new to this forum and have a few questions. For a school assignment I have to make an automated report in word using VBA and excel but I have a problem filtering the data. The file exists of 3 sheets: - control (date selection and button to generate word report) - data...

Hi all, I've got macro that does some filtering for me - the problem is pulling the data from sheet1 to sheet2 removes data formatting example : <colgroup><col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;"> <col width="93" style="width: 70pt...

Hi Guys, I'm currently experiencing a strange situation when I filter a column for #NAME it returns blank lines. The item is in the column but for some reason the filter is not returning it. You can also see in the filter drop down. My current workaround was to use find and replace and...