Dave, thanks for your help too, i've been trying to get this data - subtotal
to work with my project but i don't think it's the way to go, all this extra
information that this function adds messes up the rest of the information in
the sheet, and to be hones, it just gives you to much sub totals!. is there
another way to do this??? the big problem that i'm having on this proect is
that the data is not always the same size, i mean the titles even thought
they are on the same column, but they are not always on the same row, and
some titles have more items that others. on my 1st post i have an example of
the code, any other comments are apriciated, thanks.