Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Then Loop....
So I'm new to VBA, and am working on my first loop. I have names in
column A, Dates in Column B, and Quantity in Column C. I need to create a loop that provides me with the sum of the quantities for each name, between certain dates. ie: If name = Steve, then sum, if not, offset to next cell down. Then put the total of all the quantities for Steve in cell A1. Thanks for the help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Then Loop....
You may want to experiment with data|Pivottable. And if you need to have it
mechanized, you could record a macro when you do it manually. wrote: So I'm new to VBA, and am working on my first loop. I have names in column A, Dates in Column B, and Quantity in Column C. I need to create a loop that provides me with the sum of the quantities for each name, between certain dates. ie: If name = Steve, then sum, if not, offset to next cell down. Then put the total of all the quantities for Steve in cell A1. Thanks for the help! -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Then Loop....
ps. I'd even cheat and add another column to the data that added a formula that
evaluated to a Y or N according to the date. wrote: So I'm new to VBA, and am working on my first loop. I have names in column A, Dates in Column B, and Quantity in Column C. I need to create a loop that provides me with the sum of the quantities for each name, between certain dates. ie: If name = Steve, then sum, if not, offset to next cell down. Then put the total of all the quantities for Steve in cell A1. Thanks for the help! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
For Each ... Next loop - need to reference the loop variable | Excel Programming | |||
Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
Loop Function unable to loop | Excel Programming | |||
Problem adding charts using Do-Loop Until loop | Excel Programming | |||
HELP!!!! Can't stop a loop (NOT an infinite loop) | Excel Programming |