1. E

    VBA: Copy All Data Including Filtered Cells From Table

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

    VBA Copy and paste values of filtered rows

    I need some help get from Table 1 to Table 2 then Results please <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color...
  3. R

    Excel 2016 VBA to copy and paste not working

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

    Help this 1st then time to learn VBA!

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

    sumif only filtered area

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

    Subtotal minimum number that isn't zero

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

    how to sum two cells from different rows in filtered data

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

    Sum Product on filtered data only

    =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
  9. S

    Filtering Data

    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")...
  10. A

    Error Deleting the Rows Of A Filtered Range

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

    Macro to advance to next value in filtered data?

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

    VBA Vlookup or another best option to copy from a filtered sheet columns to other tabs?

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

    Summing filtered columns by certain criteria

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

    Looping through filtered range not working

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

    Formula to display the contents of the first filtered cell

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

    Duplicating a table to sort/filter data different ways

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

    Excel VBA filtering loop issue

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

    Month is filtered and previous month are zeroed

    Hello, I have columns Jan-Dec 2019 with a IF formula already in the cells. I need to figure out how to enter a formula that can zero out the previous month when selected, but keep the rest of the years data. For example when I filter to Mar, the current data stays and Jan&Feb will equal to...
  19. S

    Pivot Table Options

    I have created a pivot table which I added to the Data Model so I could perform distinct counts. However, I want to now be able to go to Show Report Filter Page but it is grayed out. Is there a way to now break out my pivot table by a filtered field?
  20. G

    Help in selecting and copying filtered data (Could not select single entry)

    Hi Friends, I have build a code to select the filtered data to copy and paste into another worksheet. However there is an issue with it. When there is only one entry found from filtered data, it throws an error coz it selects the data till last row of the sheet. Kindly help me to correct the...

Some videos you may like

This Week's Hot Topics