Jump to content
News Ticker
  • Welcome to the Community
  • Use the forum to troubleshoot your Excel & VBA Problems
  • We will be launching a new website soon! www.ExcelWTF.com/Learn ! Join us to learn VBA from the ground up!


  • Content count

  • Joined

  • Last visited

  • Days Won


LPowell911 last won the day on August 5 2018

LPowell911 had the most liked content!

Community Reputation

3 Neutral

About LPowell911

  • Rank
  1. LPowell911

    SUM Multiple Section

    File sent earlier today. Thank you in advance!
  2. LPowell911

    SUM Multiple Section

    Unfortunately, it didn't work . The sheet looks the same. Just an FYI, I referenced the incorrect columns (forgot a couple from memory). I changed the code to reflect accordingly still with no result. Could I send you the test file so you can see a little more in detail?
  3. LPowell911

    SUM Multiple Section

    I will have about 23-28 sections, depending on the day of the week. Do I need to set all 23-28 ranges? Or will this just loop until it finds the complete end?
  4. LPowell911

    SUM Multiple Section

    Thank you Caleeco! I will give it a try and let you know!
  5. LPowell911

    SUM Multiple Section

    Greetings, I have a report ran for me which dumps into a .xls into several different sections. Each section has a name in column B, a route in the following row in column C, and data that begins to dump in the next row Columns D through F which are time planned, time actual, and location. Each section goes about 200 +/- rows of these times and locations. After each section, there are about 5 blank rows before the next name and route section information. I got a friend to help me with a macro to count each time a certain timed event happens. These Counts occur in columns H, I , and J. One count is for early, one count for late, and one count for each stop. But now I want to add up the number of times it happens for each name and route. I am using SUM function to add up each section. The total is in the same row as the Route. I have learned about the INDEX to Next Blank, but am not sure how to write the macro for the formula to go instead of the SUM function I am typing in each cell. I want to continue this report to run and sum up each section (for each driver and route that day). B C D E F H I J K John Doe Early Late Stops Pct Route 1 1 3 5 20.00% 10:00 AM 10:01 AM 123 Main Street 1 1 10:15 AM 10:14 AM 246 Main Street 1 1 10:30 AM 10:30 AM 123 3rd Avenue 1 10:45 AM 10:50 AM 247 3rd Avenue 1 1 11:00 AM 11:10 AM 395 3rd Avenue 1 1 About Five Lines of Blank Rows Jane Done Early Late Stops Pct Route 2 2 1 5 40.00% 10:00 AM 10:01 AM 100 Cherry St 1 1 10:15 AM 10:14 AM 210 Cherry St 1 1 10:30 AM 10:30 AM 330 Cherry St 1 10:45 AM 10:44 AM 1000 3rd Avenue 1 1 11:00 AM 11:00 AM 1100 3rd Avenue 1 Thanks in advance for all help.