advanced

I use this on a number of large files (in 2003 compatibility mode because it is much faster) and when I click Data - Advanced it always comes up with the "Filter the list in place" and every time I must click "Copy to another location" before OK. Is there any way to make Copy to another...

Hello, I'm using an advanced filter vba to search for data from within a large data set onto another sheet. I've worked this before but this time it is not working. Range("Sheet_K_2D_FinancialInput").AdvancedFilter Action:=xlFilterCopy, _ CriteriaRange:=Sheet15.Range("BV4:BZ5")...

How would you set up advanced filter if you want to collect records of a dataset that contain numbers stored as text, and you want them starting with the partial text 646&"*" or 647&"*". I have a dataset where a column contains account code in text format such 6****** and I want all of those...

Hello friends :rofl: I am in need of an INDEX MATCH formula that looks up one column OR another column. Our group accounts are listed in one column and the accounts that comprise said group account are listed in another column. EG group account 15000 is in column A. 15100, 15200, 15300...

i have an advanced filter, but so far there's no relevant data so after the advanced filter, only the header row shows up and the total row (ie the row after all the data) is blank. (currently the total row as of today is 24,000 but it can change daily depending on the day's data....again, the...

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

Hi, I'm trying to set up an advanced filter that updates automatically and here's my code: Sub advancedfilter() Sheets("Sheet1").Range("A9:N151").AdvancedFilter Action:=xlFilterCopy, _ CriteriaRange:=Sheets("Sheet1").Range("K1:K2"), _ CopyToRange:=Sheets("Sheet2").Range("A8:N8") _...

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

for some reason, the advance filter only works for one criterion...when i try to expand the range...it stops working... e.g im only filtering for OSP 397 if i add another column OSP 400 the advanced filter via VBA stops working (just shows blank).....yes, I have modified the named range...

I am trying to do the following and cannot piece it together. On a password protected tab called "Advanced Tab" Have three buttons or circles that do the following. button 1 - unhide all veryhidden sheets button 2 - veryhidden 5 sheets called "S2 R", "S2 M", "S2 C", "FT", "Totals" button 3...

I have a Advanced filter that works as expected, however I would like the user to be able to add additional criteria into two of the columns so more and more information is filter out each time. This is the working filter. Sheets("data").Range("A5:Z10000").AdvancedFilter _...

Is there a way that I can have the Advanced Editor active when I reply to a thread? When I start a thread, like now, I have the Advanced Editor. But when I reply, I get some other editor and I have to click on the Go Advanced button to get it. In my Settings under Miscellaneous Options, I have...

I have an advanced filter & based on the filtered information entries needs to be manually added eg based on a value per customer a comment next to it. However the information manually entered must not be lost / misaligned every time the filter is updated Is Avanced filter still the best...

Hello Community, I am trying to match a selected cell to a reference of multiple columns. For my example, I want to choose a state and I want it to return which category it comes from. Each category has multiple unique states. Ex. I search for CA within whole time, I want it to return me the...

I currently have three column. I'd like to record a macro so that I can copy column C insert it into a new column, D, but the next time I run the macro copy D into E and so on. Currently the macro is "absolute" and always goes back to record column C. Thanks.

Hi, I am using the advanced filter with two criteria to sort a list. However, I want to use top #10 or top #25 items using auto filter. Is it possible to use top #10 with advanced filter and/or can I use auto filter on the list that I sorted using the advanced filter?

I hope I explained what I need here. So this is how it goes. 1. On Workbook A, I have a cell B4 - B7. The values are populated from Workbook B - sheetname "Fruits", cell C4 - C7 2. On workbook A again, I have cell B11 - B13. The values are populated from Workbook C - sheetname "Vegatables"...

So What I need to do is copy and paste the values from the green columns in workbook 1 into workbook 2 if its says "yes" in the last column. I then need to cycle to the next row in workbook 1 and paste the values into a NEW worksheet in workbook 2 and do the same until it no longer says yes in...

Is there a better, more efficient way to complete all these advanced filters? Sub Sort() Sheets("RequestLog").Columns("A:G").AdvancedFilter Action:=xlFilterCopy, _ CriteriaRange:=Range("Calendar!l4:M5"), CopyToRange:=Range("Calendar!l8:m15"), Unique:=False...

Hi there, I have a sheet where I have disabled 'show zero in cell where cell value is zero' in advanced options... However I have one cell where I would like 0.00 to appear. The cell is formatted as a number to 2dp If I re-enable the advanced setting to show zeros, the entire sheet fills with...