finding ranges

[ksnapp]

helo,

I have come to the conclusion that my stategy for a specfic project i
doomed to failure.

I think whit the code I have I would be able to make it work if...

Here is what I have

I have names in column A , descritions in columns B and C, and Valu
(numbers) in columns C and D. example:


name 1 big large 10 25
small large 15 36
name 2 med. small 36 65
tiny big 45 28



I think if I had a way to define from when an accounts name firs
appears to when it ends it would make the program work.

I think i need a sub that defines the range for name 1 then I can plu
in my existing code (adjusted to work). that code would do its thin
and then repeat for the next name.

Is this at all possible

 

[Frank Kabel]

Hi
you may explain what you're trying to do with this range. There could
be different approaches depending on your goal

 

[ksnapp]

i need to delete some data(rows) based on contents of columns b throug
E without removing the name

i need to sum things based on desciption and add a row that totals som
of the data

thats really the gist of it. Its just that there is so much raw data.
most of it gets deleted but it starts out w 5000+ rows.

I have been trying all different kind ways to accomplish this, but the
all seem to fall short because I can't contain the subs to just on
name area at a time


does that help

 

[Tom Ogilvy]

You haven't shown how to identify a name area.

Certainly, it is possible to break your data into subgroups is there is some
identifiable feature in your data which allows you to identify where the
separation should occur.
Is this the same chicken, steak, problem you have been posting about for
many days?

 

[ksnapp]

actually i figured a quick way around all this

it seems to work to