sum date range

  1. P

    LOOP with non blank cell

    Hi everyone, Im learning VBA and I have this code Sub [CODE]SmartRunningTotals() Dim rng As Range Dim cell As Range Dim lastRow As Long Dim totalTime As Double ' I'm assuming your time column is in column A lastRow = Range("A" & ActiveSheet.Rows.Count).End(xlUp).Row...
  2. P

    LOOP with non blank cell

    Hi everyone, Im learning VBA and I have this code Sub SmartRunningTotals()</pre> Dim rng As Range Dim cell As Range Dim lastRow As Long Dim totalTime As Double ' I'm assuming your time column is in column A lastRow = Range("A" & ActiveSheet.Rows.Count).End(xlUp).Row...
  3. J

    Pie Chart Individual Sums

    Hi, I have a few teams working for me and each team resolves tickets (Alpha, Bravo and Charlie let's say). I want to create a pie chart to compare the teams so each segment is a sum of the numbers. I can do a chart for the individual people. I can do a chart for each team that picks a person...
  4. J

    Sum a range of data based on date range

    Hi, Im new to the boards, and am relatively inexperienced in excel. I have a recurring problem with one of my spreadsheets. I have a summary sheet that pulls data from a variety of sources. One of the sources is a monthly report that is generated daily. Dates down column A for the month...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    • Started by Anton1999
    • Replies: 28
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    • Started by jaym6939
    • Replies: 26
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    • Started by dpaton05
    • Replies: 24
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    • Started by MrDB4Excel
    • Replies: 23
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top