Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping through Cells
I have an expense sheet. The data includes: Item Description, Date, Amount,
Employee I would like to calculate totals for each employee separately. This is how the data looks: Widget 1, 12/23/04, 43.45, Joe Widget 2, 12,24/04, 21.55, Edward Widget 3, 12/01/04, 15.55, Joe How can I do this automatically (each time I make a change). Sometimes there could be 10 entries, 50 entries, 20 entries, etc... I would like a way to figure out the totals when the sheet is open or becomes active. It seems using the SUMIF command, I would have to plug in the ranges. I would like to loop through the records and when there is no entry in the "employee" field, I'm done. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reference cells when looping | Excel Discussion (Misc queries) | |||
Looping thru a range of cells | New Users to Excel | |||
looping through an giving values to cells in vba | Excel Discussion (Misc queries) | |||
Looping through (active??) cells problem | Excel Programming | |||
Looping through a range of cells | Excel Programming |