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

Top