Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
WorkSheet_Change Issue
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...- jumbo1979
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Worksheet Update
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...- jumbo1979
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
SUMIF based on multiple criteria?
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- jumbo1979
- Thread
- Replies: 6
- Forum: Microsoft: Office
-
Hiding/Unhiding Rows Loop
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...- jumbo1979
- Thread
- Replies: 11
- Forum: VBA Visual Basic for Applications (Microsoft)
