Hi Excel experts!
Does anyone know how to do the following with a macro.
Column B has a list of product names; and column D has amounts. e.g.
Column B Colomn D
(Product names) (Amounts)
--------------------------------
A 2
A 3
A 1
B 7
B 9
B 2
C 4
C 9
Etc.
What I need is a macro that will total the amounts per Product and if it is above 15 then move (or remove) those rows to a spreadsheet called "check".
If sounds simple enough doesn't it? But I just can't seem to get it to work.
Usually I would do it manually with a filter and then a sumproduct (and then cut / paste) but there are to many different product names to make this feasible.
If someone knows how to do this via a macro I would really really really appreciate it
Thanks ppl!
Steven123
This message was edited by Steven123 on 2002-09-27 08:45
Does anyone know how to do the following with a macro.
Column B has a list of product names; and column D has amounts. e.g.
Column B Colomn D
(Product names) (Amounts)
--------------------------------
A 2
A 3
A 1
B 7
B 9
B 2
C 4
C 9
Etc.
What I need is a macro that will total the amounts per Product and if it is above 15 then move (or remove) those rows to a spreadsheet called "check".
If sounds simple enough doesn't it? But I just can't seem to get it to work.
Usually I would do it manually with a filter and then a sumproduct (and then cut / paste) but there are to many different product names to make this feasible.
If someone knows how to do this via a macro I would really really really appreciate it
Thanks ppl!
Steven123
This message was edited by Steven123 on 2002-09-27 08:45