-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
visible data
-
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...- Graham C1600
- Thread
- boy data ifsums multiple criteria. visible data
- Replies: 5
- Forum: Excel Questions
-
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...- Xnatal
- Thread
- filtered table loop visible data
- Replies: 2
- Forum: Excel Questions
-
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...- bfishertarget
- Thread
- cells.value vba visible data
- Replies: 10
- Forum: Excel Questions
-
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"...- mcarozza
- Thread
- copy and past sheet vba visible data
- Replies: 0
- Forum: Excel Questions
-
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...- elcentro3m
- Thread
- autofilter excel 2007 visible data
- Replies: 3
- Forum: Excel Questions
-
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)),,))))...- Gilberto Fernandez
- Thread
- sumproduct visible data
- Replies: 2
- Forum: Excel Questions
-
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...- Gilberto Fernandez
- Thread
- between values subproduct visible data
- Replies: 3
- Forum: Excel Questions
-
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...- Anteka
- Thread
- copy files to workbook macro macro help visible data
- Replies: 3
- Forum: Excel Questions
