visible data

  1. G

    Using =sumifs's with multiple search criteria and filtered data

    Hi, I have a spreadsheet with multiple sheets with multiple data. Until now it has worked really well but i have been asked to provide further MI on the data i already have. Let's say the layout is as below :_ A B C...
  2. X

    Rolling over the visible rows of a filtered table

    Hi, i'm searching for a code to go through a table and register only the visible rows of a filtered table. But all I get is it to register the first visible row of every block of rows: For i = 2 To 2000 With Worksheets("sheet1").AutoFilter.Range.SpecialCells(xlCellTypeVisible).Areas(i)(1...
  3. B

    VBA 'Cells.Value' no longer returns visible value in cell?

    Good Morning- I have a simple excel macro which is triggered by the worksheet_change event. The macro is coded like this: For q = 2 To 600 If Worksheets("Threshold Tracker").Cells(q, 1).Value = "" Then Worksheets("Threshold Tracker").Cells(q, 1).Value = Input1 Worksheets("Threshold...
  4. M

    Editing VBA to creat a new sheet without empty filtered rows

    I have the following lines of code that create several new sheets and name and filter the data as specified. However, I also want it to create a new sheet that copies the data and pastes it with visible rows only: Here is what I currently have: '**** 'Create new copy of table, name "Growth"...
  5. E

    Autofilter - Select Visible ROWS - Excel 2007

    I have several columns of data. One column is autofiltered. I exclude the one element I want to keep and show the rest. I know I can use either: F5 / Special / Visible Cells or Alt-; to select Visible Cells. I need to select (and delete) all visible rows (with data) except the header row...
  6. G

    convert SUMIF to SUMPRODUCT

    Hello, I need to convert the following SUMIF into SUMPRODUCT so it only adds visible cells. =SUMIF($A$12:$A$50000,A50003,$E$12:$E$50000) Ive tried this formula with no luck: =SUMPRODUCT(--($A$12:$A$50000=A50003),(SUBTOTAL(103,OFFSET($E$12,ROW($E$12:$E$50000)-MIN(ROW($E$12:$E$50000)),,))))...
  7. G

    SUMPRODUCT to count BETWEEN numbers and only VISIBLE cells

    Hello, Im currently using this formula to count cells that match the contents of another cell. It works perfectly only counting visible cells. =SUMPRODUCT(--($A$12:$A$50000=A50003),(SUBTOTAL(103,OFFSET($A$12,ROW($A$12:$A$50000)-MIN(ROW($A$12:$A$50000)),,)))) I need another formula to count...
  8. A

    Help! Having Issue with Copying of information with a Macro...

    Hi Guys... I really need some help... I receive a daily report as a txt file. Then I use: ChDir "C:\Users\Mon&Ant\Desktop" Workbooks.OpenText Filename:="C:\Users\Mon&Ant\Desktop\0.txt", Origin:= _ xlWindows, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _ xlDoubleQuote...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top