Hello:

I have a spreadsheet that, among other columns, has an inventory item column
and a quantity column.

The inventory item column has several records with item A, item B, item C,
etc. The number of items column has several records also with 8 for A in one
record, 2 for A in another record, 3 for A in another record, 4 for B in
another record, 5 for B in another record, 9 for C in another record, 7 for C
in another record, etc.

I want to create a macro that automatically sums the quantity of each item
A, B, and C. I'm not concerned with a total quantity for the entire
spreadsheet--just a total for each item.

How do I program Excel to have such a macro? I'm sure that the solution is
simple. I'm just not familiar with creating Excel macros.

Thanks!

childofthe1980s

You might be able to use the SUMIF worksheet function in your code to
accomplish that task...

Mark

"childofthe1980s" wrote in
message ...
Hello:

I have a spreadsheet that, among other columns, has an inventory item
column
and a quantity column.

The inventory item column has several records with item A, item B, item C,
etc. The number of items column has several records also with 8 for A in
one
record, 2 for A in another record, 3 for A in another record, 4 for B in
another record, 5 for B in another record, 9 for C in another record, 7
for C
in another record, etc.

I want to create a macro that automatically sums the quantity of each item
A, B, and C. I'm not concerned with a total quantity for the entire
spreadsheet--just a total for each item.

How do I program Excel to have such a macro? I'm sure that the solution
is
simple. I'm just not familiar with creating Excel macros.

Thanks!

childofthe1980s

Actually, no. You use Data...Subtotals. Very easy.

Thanks for the input, just the same.

childofthe1980s

"Mark Ivey" wrote:

You might be able to use the SUMIF worksheet function in your code to
accomplish that task...

Mark

"childofthe1980s" wrote in
message ...
Hello:

I have a spreadsheet that, among other columns, has an inventory item
column
and a quantity column.

The inventory item column has several records with item A, item B, item C,
etc. The number of items column has several records also with 8 for A in
one
record, 2 for A in another record, 3 for A in another record, 4 for B in
another record, 5 for B in another record, 9 for C in another record, 7
for C
in another record, etc.

I want to create a macro that automatically sums the quantity of each item
A, B, and C. I'm not concerned with a total quantity for the entire
spreadsheet--just a total for each item.

How do I program Excel to have such a macro? I'm sure that the solution
is
simple. I'm just not familiar with creating Excel macros.

Thanks!

childofthe1980s