filtered

Hi, I have the code ActiveSheet.Range("A10").Offset(1, 0).Select But this does not work for me as my data is filtered. I do not want to unfiltered the data. But how can I use offset on functioning with on the cells that are visible ?

Hi all, I have a code that filters data, and then I have the following function: If IsEmpty(Range("A14").Offset(1, 0)) = False Then 'Is not blank MsgBox "ABC" Else 'Is blank MsgBox "XYZ" Essentially I'm trying to see if the next available row in the data is...

There have been numerous posts about how to count the number of unique values existing in a specific column of a filtered table. Responses often point to array formulas that use a combination of the FREQUENCY, SUBTOTAL and MATCH functions, for example...

Hello All, I'm copying information from a table on the server and pasting the data onto another workbook. The problem is the table is always being filtered so when the macro runs it pastes the visible data only and not the entire table. Any help would be appreciated, thank you in advance, -E...

I need some help get from Table 1 to Table 2 then Results please Book1ABCDEFGHIJKLM1Table 1Table 2456Results21231617181617183456Y1920211920214789Y22232422232451011122526272526276131415Y282930282930Sheet1 Book1ABCDEFGHIJKLM1Table 1Table...

Hello, I’ve been using the code below for many years and when I updated to Excel 2016, the results are no longer pulling correctly. After the filter is set, the range that’s pasted to the new workbook is showing cells that are hidden and if some of the cells do not contain data, its shifting...

Wow - what a forum! Thought I was "OK" in excel but while going through this forum I just realized im nothing but a complete n00b! :laugh: So, this summer will be dedicated to learn coding excel macros but I have a repeated task going on at work which I guess is an easy 2min task for any pro...

Hi, i need to add only filtered area if criteria is met.... I am adding quantity of sales by salesperson. B2 is salesperson name H2 is the total quantity sold in filtered area. This is the cell i need calculated. C13 to C1000 is salesperson name D13 to D1000 is quantity sold for each sale...

Trying to get the following, but cannot figure the formula to get my desired output described. Subtotal(5,H4:H15) - the minimum number in a filtered list that isn't zero. Likewise, Subtotal(4,H4:H15) - the max number in a filtered list that is below 400 (or whatever I decide) Any thoughts...

Hi Guys, I have a formula adding (for example) a1+ b2, a2+b3, a3 +b4 ect ect. A B 1 3 7 2 10 14 3 5 11 4 13 2 5 4 6 if I filter column A in the above example to cells less than "10' the example would look like this: A B 1 3 7 3...

=SUMPRODUCT(--('GRIP STAGES'!$C$5:$C$4000=$B8),'GRIP STAGES'!T$5:T$4000) How would I alter this so that it returns only the sum total of the source data that is filtered? thanks

I created these formulas on a separate sheet and I need help with changing it so when the source sheet is filtered it only shows what is filtered and not all the data, any help would be greatly appreciated! =SUMIFS(OT_COMP!I2:I1048576,OT_COMP!B2:B1048576,"OT",OT_COMP!E2:E1048576,"Place Holder")...

I am trying to delete the rows on a filtered worksheet with this code: .Range("A:R").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=ws_vhold.Range("A2:A3") Set RngList = .Range("A1:R" & .Cells(Rows.Count, "A").End(xlUp).Row).SpecialCells(xlCellTypeVisible) RngList.Resize(Rows.Count -...

Hello, I have a spreadsheet with over 1600 rows of data. In Column A, there are around 250 or so unique values. I currently have column A filtered so that I can just look at the rows with the specific value I want to see in column A. Is there a way to run a macro so that the filtered data...

Hi there I have some imput data sheets that will be filtered by country. Using what's filtered, I need to populate that info into other sheets. At the moment, I am using VBA to populate one column, then within that sheet, I am just doing vlookups but I wonder if there is a better way to do...

Hi there, I'm having an issue of finding a way to sum certain "profits" based on a variable/ criteria while filtered. I tried using Sumif function, but when data gets filtered it still sums the "hidden" data. is there a way to create a formula that changes the sum value when filtered. for...

As my users use a spin button to move up/down through a column of IDs, my code finds that ID which is used in many other calculations in fields and cells. BTW, this spin button is in a userform. When that column is not filtered, everything works fine. But when the column is filtered, I want my...

Hello kings i want A Formula to display the contents of the first filtered cell Exemple like this pic

Hello. I'm looking for a way to duplicate a 'master' Excel table so I can have the exact same table copied multiple times, side-by-side, but with each table sorted and/or filtered slightly differently. The idea is that only the 'master' table be edited and the other tables feed off of it and...

Hi guys! Trying to implement a VBA loop the first time and struggling with it. I have table Table1; separately defined range Filtered (same area as Table1, however no headers) and hardcoded array of values Arr. I want VBA to cycle through all those values in array and use each of them to filter...