That worked pefectly. Now what I'd like to do is remove the groups of data
where
the subtotal is less than $10,000. I'm new to writing code but I believe I
can search "total" and use if then statements to determine of the subtotal is
less than
$10,000 but once I determine that how can I select the range of data above
and delete?


"Matthew Herbert" wrote:

Peruanos72,

Have you tried the built-in Subtotal option in Excel? This option usually
requires you to create column headers. Once the column headers are created
select the data set and run Subtotal. Subtotal will ask you to specify the
"At each change in", "Use funciton", and "Add subtotal to" parameters. This
should be of help to you. (Also, search for SUBTOTAL in the help
documentation and read the help file).

Best,

Matthew Herbert

"Peruanos72" wrote:

I have multiple lines of data in columns A,B, C, D,E,F,G AND H where column H
contains a dollar value. The data in each column, except H is the same for
multiple rows and then the data in columns A,B, C, D,E,F,G changes. This
continues for multiple rows. What I need to do is somehow seperate the lines
of data into groups where the data in columns A,B, C, D,E,F,G are the same so
I can then subtotal column H for that group of data.

Example:

I need to subtotal the dollar value for ABC, HER and KLE
Note: The data will change from day to day so I can't simply search for a
particular value.

ABC 2009040 780312737 8 WAFRIJEN 6/4/2009 204984337001 $500.00
ABC 2009040 780312737 8 WAFRIJEN 6/4/2009 204984337001 $248.00
ABC 2009040 780312737 8 WAFRIJEN 6/4/2009 204984337001 $300.00
HER 2009041 780748728 8 522660V1 6/4/2009 571201170018 $5,896.00
HER 2009041 780748728 8 522660V1 6/4/2009 571201170018 $4,785.00
KLE 2009042 780546059 8 3469-1-7 6/2/2009 521779986001 $4,456.00
KLE 2009042 780546059 8 3469-1-7 6/2/2009 521779986001 $12,489.00


Thanks in advance!!