Search results for query: *

Ken, This works perfectly. Thanks! One more question - in the same code, How do I get it to sort descending on column C after all of the data is populated? thanks happy jumbo

PH, When I add "- 2" to lRow I get an error: Run-time error '1004': Application-defined or object-defined error Any thoughts? thanks jumbo

My goal is to have the result of: 11:29:30 AM United States 2,575,517 0.1046% 11:29:30 AM Japan 6,013,355 0.2442% 11:29:30 AM Hong Kong 669,088 0.0272% update every time the data from wrksheet1 refreshes. However with the current VBA in my wrksheet it continues to grow row by...

I have: Private Sub Worksheet_Change(ByVal Target As Range) code in this worksheet so that the code runs everytime the data refreshes, however the data is all formulas linked to another worksht. So even though the data values are changing - the actual data is NOT changing so the Change code...

The cells in the worksheet with the data I want to manipulate are sumif formulas grabbing data from another worksheet in the book.

I have a data set that is dynamic and refreshes every 5 seconds. I would like to do several things to this data set. 1. Hide any rows that have a value of 0 in column B 2. Unhide any rows that have a value that is not 0 in column B 3. Sort the remaining unhidden columns descending by column B...

Not sure I am running this right. Does this look correct? Sub Test() Dim lLastRow As Long, lRow As Long For lLastRow = sheetobject.Cells(sheetobject.Cells.Rows.Count, 2).End(xlUp).Row For lRow = 1 To lLastRow With sheetobject.Cells(lRow, 1) Selection.EntireRow.Hidden = False If...

OK - so I got to this code: Sub UnHide_Hide() Application.ScreenUpdating = False Dim i For i = 1 To 130 With Intersect(Columns(2), ActiveSheet.UsedRange) Rows(i).Select Selection.EntireRow.Hidden = False If .Rows(i).Value = 0 Then Selection.EntireRow.Hidden = True End If End With Next...

this does not work: Sub Update() Selection.AutoFilter Selection.AutoFilter Field:=2, Criteria1:="0" ActiveCell.Offset(8, 0).Rows("1:1").EntireRow.Select Range(Selection, Selection.End(xlDown)).Select Selection.EntireRow.Hidden = True Selection.AutoFilter...

Is it possible to use the sumif function based on two criteria? ex. of current line: =SUMIF('All Data'!$Z$2:$Z$10017,"JAP",'All Data'!$D$2:$D$10017) And I would like to somehow also include AND IF ('All Data'!$AF$2:$AF$10017,"<>*US*") into the above function let me know thanks jumbo

I have a data set that is dynamic and refreshes every 5 seconds. I would like to do several things to this data set. 1. Hide any rows that have a value of 0 in column B 2. Unhide any rows that have a value <>0 in column B 3. Sort the remaining unhidden columns descending by column B 4. Repeat...